To set general options
Click in the main menu.
Review the following for additional information:
General Options | Description |
Restore Layouts |
Click |
Launching from Other Applications | Description |
Launch SQL Optimizer from other applications |
Click |
Note: These options apply to SQL Optimizer and SQL Scanner.
SQL Optimizer classifies SQL into categories in the Scan SQL, Find SQL, and Optimize SQL modules. You can use this page of the Options dialog to enable/disable classification rules, or to create new rules.
To set SQL classification options
Click in the main menu.
Tips:
Use this option to invoke Microsoft SQL Server functionality that checks your SQL for compliance with the SQL-92 standard. The compatibility results display in the Alerts window after the optimization process.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set Ansi-SQL options
Click in the main menu.
Review the following for additional information:
Check compatibility to SQL-92 standard level |
Select this checkbox to verify whether SQL statements meet the Ansi SQL-92 standard when the SQL statements are classified as Simple, Complex, or Problematic. You can also select the SQL Server compliance level for checking using the following:
|
Note: These options apply to SQL Optimizer and SQL Scanner.
To set execution plan options
Click in the main menu.
Review the following for additional information:
Table Scan warning threshold (records) |
Specify the threshold at which you want to receive a warning. |
A/E Rows Relative Discrepancy warning threshold |
Specify the threshold at which you want to receive notification of the difference between actual and estimated rows. Specify threshold to receive notification of actual/estimated (A/E) Relative Discrepancy. |
Color |
Select the color of individual items in the execution plan. |
Font | Select the font settings of the individual items in the execution plan. |
Note: The execution plan displays in several panes. The color and font settings in this window controls the settings in all the Execution Plan panes. Right-click the execution plan and select Plan Options to customize display options for individual panes. |
Note: These options apply to SQL Optimizer and SQL Scanner.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center