You can filter the SQL statements displayed on the Time tab and the Statistics tab of the SQL Optimizer window by any of the run time statistics after you have executed the SQL statements so that the run time statistics are displayed on the Time tab and the Statistics tab.
The current filter displays in the bottom left corner of the Time or Statistics pane.
To filter the SQL statements
Click the downward pointing arrow to the right of a column heading.
Select one of the following:
Item | Description |
All |
Displays all the SQL statements. |
Custom… |
Opens the Custom AutoFilter window where you can select the options for filtering the SQL statements based on specific values for the selected column. |
Blanks |
Select all the SQL statements which do not have a value in the selected column. |
NonBlanks |
Select all the SQL statements which do have a value in the selected column. |
Specific Value |
Select all SQL statements that have one specific value. |
You can repeat steps 1 and 2 to add as many filters as you would like.
To clear the filter
Click at the bottom-left corner of the Time or Statistics pane.
The Find SQL function is available in the SQL Optimizer window. This enables the location of SQL statements that contain a specified text string.
To find text in a SQL statement
Select SQL | Find SQL to open the Find SQL window.
Enter the text string to be found and click Find.
To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].
The details of the SQL statements and run time results in the SQL Optimizer window can be generated into a report.
To generate the Optimized SQL report
Select Report | Optimized SQL to open the Optimized SQL Report Criteria window.
Select the components for the report.
Select All SQL or Select SQL and enter the specific SQL statement numbers.
Note: A few minutes may be needed to generate a long report.
You can verify the correctness of optimized SQL statements by comparing it with the original SQL statement using the Run Result function and by looking at the No. of Records column in the Time tab in the SQL Optimizer window after retrieving the run time. This information enables you to see whether the optimized SQL statement provides the same results as the original SQL statement.
The Run Result function retrieves the queried records from the connected database.
In the Run Time pane of the SQL Optimizer window, the No. of Records displays the total number of records influenced by the SQL statement. This figure should remain constant for both the original and optimized SQL statements.
In the Run Time pane of the SQL Optimizer window, the First Record indicates the first record retrieved either 0 or the number of records that was selected for First n Records in the Run Time Mode page in the Batch Run Criteria window . This figure should remain constant for both the original and optimized SQL statements.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center