View Schema Information
This topic may not include a description for every field in the screen or dialog.To view schema information
- Select the Optimize SQL tab in the main window.
-
Select Plan Control from the Optimize SQL start page.
-
Select the Schema Information tab in the Plan Control window.
Tip: Click
to retrieve all schema objects.
-
Click
beside the Summary list and select a table for additional information.
Tips:
- Select a row in the Statistics Summary pane and click
for additional information.
- Click
to reorganize indexes.
View SQL Information (Optimizer)
View Bind Variables
This topic may not include a description for every field in the screen or dialog.
To view cursor settings and bind variables
- Select the Optimize SQL tab in the main window.
-
Select the Cursor and Bind Variables tab in the Optimize SQL window.
-
Review the following for additional information:
- The parameters for the bind variable defined for your SQL statement are displayed in the bottom pane. See Set Bind Variables for more information.
Note: Information is only displayed in this tab if you used cursor settings or variables for optimization.
View SQL Information (Optimizer)
View Execution Statistics (Plan Control)
Show or Hide Table Attributes
This topic may not include a description for every field in the screen or dialog.To show or hide a table attribute
- Select the Optimize SQL tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Right-click the header row in the Summary Details pane and select Column Chooser.
-
Add or remove table attributes by dragging the column names to and from the Customization dialog.
Show or Hide Index Attributes
This topic may not include a description for every field in the screen or dialog.To show or hide an index attribute
- Select the Optimize SQL tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Click
-
Right-click the header row of the Index Attributes pane and select Column Chooser.
Note: The Index Attributes pane is the first pane in the Schema Information tab.
-
Add or remove index attributes by dragging the column names to and from the Customization dialog.