SQL Optimizer provides two different measurements of performance; run time for all records and the run time the first record. ... Both measurements will provide an indication on the fastest running...
The Find search function brings up the Find Text window where you can select the search criteria. ... The search is refined in the Find Text window using the following settings: ... Searches for th...
The details of the SQL and index-set alternatives and their run-time results can be generated into a report. ... To generate the Optimized SQL Report ... Select Report | Optimized SQL to open the O...
The Compare tab in the SQL Optimizer window enables you easily to compare SQL text, access plans, and statistics between two alternatives or between an alternative and the original SQL. ... The Com...
Select the specific SQL to save and click the Save button. ... Select the location in which to save the SQL statements. ... Only valid SQL statements can be added to the SQL Repository.
In the New Analysis wizard, the Index page is used to specify the index(es) that are used for this analysis. ... An individual Index Impact Analyzer consists of a group of stored SQL statements wit...
Specify to retrieve the run time for processing All Records. ... First n Record(s) ... Specify to retrieve the run time for processing n records where you specify the number of records retrieved.
Use this procedure to save all the current SQL and index-set alternatives and their test results to a file that you can later reload into a SQL Optimizer session. ... To save the current SQL and in...
The Search functions search through the current text pane to find the text search string. ... This applies to text pane that are editable with a white background (Windows default color) and the pan...
There are many ways to customize the behavior of editable panes; the editor options can be set in the Options window under the Editor tab. ... These options include: ... Specify whether to use the ...
Availability of the toolbar buttons varies according to the active module. ... Buttons appear active when they are accessible and appear dimmed when they are not. ... By default all toolbar are shown.
Below is a list of available functions within the Index Usage Analyzer window. ... Function
Displays the selected schema and lists available schemas. ... Use the Schema list to select the schema that corresponds to the SQL statements that you are working with. ... Login ... Displays the D...
Below is a list of available functions within the Job Manager window. ... Function
The access plan can be displayed in different ways to help you get a clear picture of the steps or detailed information about the steps that DB2 LUW is taking to execute a SQL statement. ... For ea...
The General page of the General tab on the Options window allows users to specify the general settings. ... Specify the language set used to enter and display SQL and data. ... This setting does no...
The Open Optimized SQL Details window displays information about the SQL Rewrite and Generate Indexes processes and the resulting access plans. ... The Open Optimized SQL Details window appears aft...
To search for a specified text in all Inspectors ... Select Inspector | Find Inspectors. ... Enter the search text string ... Click Find. ... Related Topics ... SQL Inspector Overview ... SQL Inspe...
To facilitate the construction of an SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows. ... A new line and a comma will separate each column name when it i...
Tip: To save all settings on the Batch Run Criteria dialog for subsequent batch runs, select Save setting for the next batch run. ... Run all SQL twice if original SQL runs faster than (Seconds) Th...
Quest SQL Optimizer for IBM® DB2® LUW maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. ...
In the Index Impact Analyzer pane, the following information is displayed in the right pane. ... Provides a summary of the DB2 LUW Cost and SQL classification for the SQL statements before and afte...
You can copy the data from a single cell, a row, or a column into the Windows clipboard from the Database Explorer and the Parameters windows. ... To copy data ... Select the table or view name dis...
In the Index Usage Analyzer window, when a table is selected under the Tables Analyzed section is selected in the left pane, the following information is displayed in the right pane. ... Unused Ind...
The technique of creating temp tables to extract data from permanent tables is often used, because the existence of the temp table is session related and you will need to create them within SQL Opt...
New Product Association