Obtaining Index Consultant recommendations for a query

You can access Index Consultant recommendations for a query in Sybase Central.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Many.

 Obtain Index Consultant recommendations for a query

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Right-click the database and click Open Interactive SQL.

  3. In the SQL Statements pane, type the query.

  4. Click Tools » Index Consultant and follow the instructions.

Results

The recommendations of the Index Consultant appear in the Summary pane of the Index Consultant wizard.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1