Use the Alternatives pane to review the SQL text and execution plan for the alternatives SQL Optimizer generates. You can also review the run-time statistics for your original SQL statement and the alternatives after you execute the statements.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To review details for an alternative
Select an alternative in the Alternatives pane.
Review details for the alternative in the Alternative Details and Execution Plan panes.
Automatically Optimize SQL Statements
| Status | Displays client status. |
| Status | Displays client status. |
| Elapsed Time | Displays the execution time to retrieve the entire result set. |
| SQL Information | Description |
|
SQL name |
Name of the SQL statement. |
|
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 in the SQL Classification Options menu. |
|
Note:SQL Classification information only displays for the original SQL statement. | |
Classification