Contents Index Assessing the recommendations Indexes in the system tables

ASA SQL User's Guide
  Working with Database Objects
    Working with indexes
      Understanding the Index Consultant

Implementing the recommendations

The Index Consultant provides its recommendations as a SQL script. You can implement the recommendations from the Index Consultant, or you can save the script for later use.

The names of the proposed indexes are generated from the name of the analysis. You may wish to rename them before creating the indexes in the database.

For information on running command files from Interactive SQL, see Running SQL command files.


Contents Index Assessing the recommendations Indexes in the system tables