ASA SQL User's Guide
Working with Database Objects
Working with indexes
Understanding the Index Consultant
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.