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 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:
|
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 Schema Information tab in the Optimize SQL window.
Click beside the Summary list and select a table for additional information.
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 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.
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 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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center