Review Alternatives
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 the SQL Details tab in the main window.
-
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. |
Classification| 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. | |