SQL Optimizer for DB2 LUW 5.0 - User Guide

Rename an Index Impact Analyzer

You can rename an analysis in the Index Impact Analyzer window in two ways.

To rename an Analyzer

1. Select the Analysis you want to modify from the left pane.

2. Right-click and select Rename. Change the name and press Enter.

or

Select Modify and change the name.

Delete an Index Impact Analysis

To delete an analysis

1. In the Index Impact Analyzer window, select the analysis you want to delete in the left pane.

2. Right-click and select Delete.

Index Impact Analyzer Functions

Below is a list of available functions within the Index Impact Analyzer window.

Index Usage Analyzer

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. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer