Performance improvement for a SQL statement could be obtained by creating indexes to reduce I/O consumption. By sending a SQL statement to the Index Advisor module, you can obtain recommendations for new indexes that could change SQL performance.
If you are in a module that has a SQL Text pane, you can send a SQL statement to the Index Advisor.
To send a SQL statement to the Index Advisor and automatically start the index recommendation process
Select the SQL statement you want to generate indexes for.
Click Send to Index Advisor .
Note: The Index Advisor only supports a single SELECT, INSERT, UPDATE and DELETE SQL statement.
SQL statements saved in the SQL Repository can be copied into the SQL Optimizer, SQL Formatter, or SQL Worksheet.
To open a SQL statement from the SQL Repository
In the SQL Optimizer, SQL Formatter, or SQL Worksheet., select Edit | Open SQL from SQL Repository.
Navigate through the tree structure and select the SQL statement.
Either double-click the SQL statement, or click Open.
If you are using this function from the SQL Scanner, you can send multiple SQL statements to the SQL Repository. If you are using this function from the other modules, you can send one SQL statement to the SQL Repository.
To save multiple SQL statements to the SQL Repository module
In the SQL Scanner, select the Job which contains the SQL statements. In the SQL Inspector, click in the SQL Text pane.
Click Save SQL to SQL Repository .
Select the location in which to save the SQL statements and click OK.
To save a SQL statement to the SQL Repository module
In the modules with a SQL Text window, select a SQL statement.
Click Save SQL to SQL Repository .
Select the location in which to save the SQL statements and click OK.
Only valid SQL statements are added to the SQL Repository.
Note: The SQL Repository only supports a single SELECT, INSERT, UPDATE or DELETE SQL statement.
All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory 4.6 or later.
To create a file to import into Benchmark Factory
Right-click and select Create Benchmark Factory Import File.
Select the specific SQL statements that you want to save.
Enter the filename and select the file location.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center