ASA SQL User's Guide
  Working with Database Objects
    Working with indexes

Stopping the Index Consultant

The Index Consultant does have an impact on database performance while it is capturing a workload for analysis. For this reason, the database server window displays an informational message while the Index Consultant is capturing a workload.

Usually, the Index Consultant is stopped from the Sybase Central user interface. There may be occasions when it is necessary to stop the Index Consultant from another machine: for example, if the Index Consultant is inadvertantly left running.

To pause or stop the capturing of a workload, call the sa_pause_workload_capture procedure or the sa_stop_workload_capture, respectively:

call sa_pause_workload_capture;
call sa_stop_workload_capture;

To stop the Index Consultant, call the sa_stop_index_consultant system stored procedure:

call sa_stop_index_consultant