Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Query optimization and execution » Improving query performance » Indexes

 

Improving index performance

If your index is not performing as expected, you may want to consider the following actions:

These measures are aimed at increasing index selectivity and index fan-out, as explained below.

 Index selectivity
 Index structure and index fan-out

Composite indexes