Chat now with support
Chat mit Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

View Index Impact Analysis Details

ClosedView the Index Impact Analysis Details Window

The Index Impact Analysis Details window displays information about the creation of the indexes and the retrieval of the access plans. The Index Impact Analysis Details window appears after the Index Impact Analysis process is completed unless the Show details on next generation checkbox in the Index Impact Analysis Details window is unchecked.

To view the Index Impact Analysis Details window

After an Index Impact Analysis is complete, select View | Last Index Impact Analysis Details when the Index Impact Analyzer window is active. 

Review this information to see if an error occurred during the retrieval of the access plan. Errors may occur if the selected SQL statements are from one schema and you have set another schema in the Schema list at the bottom left of the main window.

 

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. This process will re-execute the Scenario.

To add SQL statements

  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.

 

Add Scenario

After creating an Index Impact Analysis, you can add more Scenarios to it. A Scenario can be added in two ways:

To add a Scenario to an Analyzer

Method One

  1. In the left pane, right-click the Analyzer and select Add Scenario.

  2. Click the Index page and specify the information for the proposed new indexes.  

Method Two

  1. In the left pane, right-click an Analyzer and select New Analysis.

  2. Select the Continuing an existing Analyzer using the Analyzer’s selected SQL option.

  3. From the Select Analyzer box, click the Analyzer name.

  4. Click the Index page and specify the information for the proposed new indexes.

 

Modify Index Impact Analyzer

To modify the analysis name or description

  1. From the Index Impact Analyzer window, select the Analyzer you want to modify from the left pane.

  2. Right-click and select Modify to open the Modify Analyzer window.

  3. Modify the name or description.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen