Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » Index Consultant

 

Obtaining Index Consultant recommendations for a query

You can access Index Consultant recommendations for a query in Interactive SQL.

Prerequisites

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
 Task

  1. In Interactive SQL, connect to the database.

  2. In the SQL Statements pane, type a SELECT, UPDATE, or DELETE statement.

  3. 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.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0