Hi all,

In 9.0.2. the Index Consultant exists on Sybase Central and Interactive SQL.

However, in 11.0.1. I can only find it in the latter.

You could used to right-click on a database in Sybase Central and keep the
Index Consultant up checking for queries that may benefit with a new index.

How do you achieve that in 11.0.1.?

Cheers,

Shao

Starting with Version 10 the index consultant is integrated into
Application Profiling in Sybase Central. Here is the help entry:

SQL Anywhere Server - SQL Usage » Monitoring and Improving Database
Performance » Improving database performance » Index Consultant » Obtain
Index Consultant recommendations for a database

Obtain Index Consultant recommendations for a database
To obtain Index Consultant recommendations for an entire database, use
the Application Profiling mode in Sybase Central. The Index Consultant
needs profiling data before it can made 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.

To obtain Index Consultant recommendations for a database using
Application Profiling Wizard (Sybase Central)
Connect to the database as the DBA, or as a user with PROFILE authority.

Choose Mode » Application Profiling.

Follow the Application Profiling Wizard instructions.

If the Application Profiling Wizard does not appear, choose Application
Profiling » Open Application Profiling Wizard, and follow the wizard
instructions until it completes.

In Sybase Central, choose Application Profiling » Run Index Consultant
On Tracing Database.


Glenn

Shao Chan wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Hi Glenn,

Thanks for that. I'll give it a try!

Cheers,

Shao

"Glenn Paulley [Sybase iAnywhere]" <paulley (AT) ianywhere (DOT) com> wrote