SQL Optimizer for SAP ASE 3.9

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 $image\B_CopytoIndexAdvisor.gif$ .

Note: The Index Advisor only supports a single SELECT, INSERT, UPDATE and DELETE SQL statement.

Open SQL from SQL Repository

SQL Information and Functions > Open SQL from SQL Repository

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.

Save SQL to SQL Repository

SQL Information and Functions > Save SQL to SQL Repository

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 $image\B_SaveSQLtoSQLRepository.gif$ .
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 $image\B_SaveSQLtoSQLRepository.gif$ .
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.

Create Benchmark Factory Import File

SQL Repository > Create Benchmark Factory Import File

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.

제품을 선택하십시오.

더 나은 서비스 제공을 위해 채팅 목적을 작성해 주십시오.

문제에 대한 권장 솔루션

SQL Optimizer for SAP ASE 3.9 - User Guide

Send to Index Advisor

Open SQL from SQL Repository

Save SQL to SQL Repository

Create Benchmark Factory Import File