View Optimization Details
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view optimization details
- Select the SQL Details tab in the main window.
- In the Alternatives pane, click
.
-
Select the SQL Information tab in the Optimize SQL window. Review the following for additional information:
Optimization Details Description Intelligence level
Intelligence level used for optimization. This option is set on the Optimizer Intelligence options page. Intelligence Options Semantically equivalent SQL statements
Number of semantically equivalent SQL statements generated by SQL Optimizer. Alternative execution plans produced
Number of alternative execution plans produced for the original SQL statement. SQL statements eliminated due to identical execution plans
Number of statement alternatives eliminated with the same execution plan as the original SQL statement.
Note: SQL statements with the same execution plan produce the same run time because the database executes these statements in the same way. Therefore, SQL Optimizer eliminates alternatives with equivalent execution plans.
Optimization Time Details Description Optimization started at
Time optimization started. Optimization finished at
Time optimization finished. Total optimization time
Total time to complete optimization. Average optimization time
Average time to generate each statement alternative. Notes:
- This information is only available after you generate SQL alternatives.
- Optimization details only display for the original SQL statement.
View Schema Information
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view schema information
- Select the SQL Details tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Click
beside the Summary list and select a table for additional information.
View Bind Variables
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view bind variables
- Select the SQL Details tab in the main window.
-
Select the Bind Variables tab in the Optimize SQL window.
The parameters for the bind variable defined for your SQL statement display. Set Bind Variables
Note: Information is only displayed in this tab if you used variables for optimization.
Show or Hide Table Attributes
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To show or hide a table attribute
- Select the SQL Details 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.