Creating indexes using a wizard

Use the Index wizard to determine which indexes to create for a given set of SQL statements. The wizard will make recommendations based on the workload that you specify. If the workload does not accurately reflect actual statements executed against your database, the recommendations will not improve the performance of your database.

Authorities and privileges



To determine which indexes to create for a given set of SQL statements:

  1. Open the Create Index wizard:
    1. From the Control Center, expand the object tree until you find the Indexes object.
    2. Right-click the Indexes folder and select Create --> Index Using Wizard from the pop-up menu. The Create Index wizard opens.
  2. Follow the steps in the wizard to complete your task.



Related information