To view SQL information
Select a Plan Control session.
Select the SQL Information tab in the Optimize SQL window. Click the following to view the information that displays for each pane.
|Statement type as classified by SQL Optimizer. Types include Simple, Complex, or Problematic.|
|Classification Rules Detail||Description|
|Applicable SQL Classification Rules. Rules used for the classification process are set on the SQL Classification Options page.|
Note: SQL Classification information only displays for the original SQL statement.
|Plan Generation Details||
|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 because they had the same execution plan as the original SQL statement.
Note: SQL statements with the same execution plan have the same run time because the database executes these statements in the same way. SQL Optimizer eliminates these alternatives.
|Plan Generation Time Details||Description|
|Plan generation started at||Time plan generation started.|
|Plan generation finished at||Time plan generation finished.|
|Total plan generation time||Total time to complete plan generation.|
|Average plan generation time||Average time to generate each plan alternative.|
View Schema Information
View Execution Statistics