ASA SQL User's Guide

Working with Database Objects

Working with indexes

Starting the Index Consultant

The Index Consultant guides you in the proper selection of indexes. You can use the Index Consultant in the following ways:

• Interactive SQL    You can use the Index Consultant from Interactive  SQL to analyze the benefits of indexes for an individual query.

• Sybase Central    You can use the Index Consultant from Sybase Central to analyze the benefits of indexes for a workload, or set of database requests.

To start the Index Consultant (Sybase Central)

1. In the left pane of Sybase Central, right-click the Indexes folder.

2. From the popup menu, choose Index Consultant.

To start the Index Consultant (Interactive SQL)

1. Enter a query that you wish to analyze into the SQL Statements pane of Interactive SQL.

2. Choose Tools > Index Consultant.

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.