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.
| SQL Information | Description |
|
Classification |
Statement type as classified by SQL Optimizer. Types include Simple, Complex, or Problematic. |
| Classification Rules Detail | Description |
|
Details |
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 |
Description |
| 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. |
|
Notes:
| |
View Schema Information
View Execution Statistics
Classification