SQL Optimizer for SQL Server 10.1.2

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: This information is only available after you generate SQL alternatives. Optimization details only display for the original SQL statement.

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.

SQL Optimizer for SQL Server 10.1.2 - User Guide