To view SQL information
Click the following to view the information that displays for each pane.
SQL Information | Description |
SQL name |
Name of the SQL statement. |
Classification |
Statement type as classified by SQL Optimizer. Types include Simple, Complex, or Problematic. Note: SQL Classification information is not available for statements from imported sessions. |
Classification Rules Detail | Description |
Details |
Applicable SQL Classification Rules. Rules used for the classification process are set on the SQL Classification Options page. See SQL Classification Options for more information. |
Note: SQL Classification information only displays for the original SQL statement. |
Optimization Details | Description |
Intelligence level |
Intelligence level used for optimization. This option is set on the Optimizer Intelligence options page. See Intelligence Options (Optimization) for more information. |
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. |
Warning Details | Description |
Details |
Information about Hints or Table Join Permutation Quotas reached. These quotas are set on the Optimizer options pages. See Hints Options or Quota Options for more information. |
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:
|
Index Details | Description |
Intelligence level |
Intelligence level used for index generation. This option is set in the Index Generation Intelligence options menu. See Intelligence Options (Index Generation) for more information. |
Indexes have been generated |
Number of indexes generated. |
Index sets were composed to generate different execution plans |
Number of index sets produced to generate alternative execution plans. |
Index sets eliminated due to identical execution plans |
Number of index sets eliminated because Database Engine Tuning Advisor information indicated they are not used by the original SQL statement. |
Indexes have been used in index sets |
Number of indexes used in the selected index set. |
Index Time Details | Description |
Index started at |
Time index generation started. |
Index finished at |
Time index generation finished. |
Total index time |
Total time to complete index generation. |
Average index time |
Average time to generate each index set. |
Virtual Index Settings | Description |
Rows sampled (%) |
Percentage of rows sampled during index generation. |
Note: This information is only available after you generate index alternatives. |
Alert Details |
Alert messages about one or more of the following:
|
Note: This pane is only available if SQL Optimizer generates alert messages. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center