Obtaining Index Consultant recommendations for a database

To obtain Index Consultant recommendations for an entire database, use the Application Profiling mode in Sybase Central.

Prérequis

You must have the DIAGNOSTICS system role or all of the following system privileges:

SELECT ANY TABLE
INSERT ANY TABLE
DELETE ANY TABLE
UPDATE ANY TABLE

Additionally, you must have the MANAGE PROFILING, SERVER OPERATOR, and SELECT ANY TABLE system privileges.

Contexte et remarques

The Index Consultant needs profiling data before it can make its recommendations. The following procedure is a quick way to gather data and obtain the recommendations using data gathered by the Application Profiling Wizard. However, if you already have application profiling data (for example, if you profiled your database already using the Database Tracing Wizard), you can also run the Index Consultant on the tracing database that you created.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Click Mode » Application Profiling.

If the Application Profiling Wizard does not appear, click Application Profiling » Open Application Profiling Wizard, and follow the wizard instructions until it completes.
Follow the instructions in the Application Profiling Wizard.
In Sybase Central, click Application Profiling » Run Index Consultant On Tracing Database.
Follow the instructions in the Index Consultant Wizard.

Résultat

The recommendations of the Index Consultant are displayed.

Discuter à propos de cette page dans DocCommentXchange.