SQL Optimizer for SAP ASE 3.8 - Release Notes

Add SQL to an Index Impact Analysis

After creating an Index Impact Analysis, you can add more SQL statements from the SQL Repository to it.

To add more SQL statements to an Analysis

1. From the left pane, select the Analyzer in which you want to add the SQL.

2. Right-click and select Add SQL.

3. In the Add SQL window under the Select SQL to be added pane, check the SQL statements you want added.

4. Under the Select Scenario to include SQL pane, check the Scenarios you want the SQL added to.

5. Click OK to add the SQL, retrieve the query plans and re-execute the Scenario.

Related Topic

Index Impact Analyzer Window