Spotlight on SAP ASE 2.12 - User Guide

Index Efficiency tab

Use the information in the User Index Efficiency – Pages Retrieved graph to monitor the percent of the time that the user retrieved a page from an index for the process selected in the User Activity grid.

This graph helps to show how efficient the application and related database structure is designed. The goal, of course, is to retrieve as much data as possible from a database using indexes. This is typically much more efficient.

*Available only for Adaptive Server versions 12.5.0.3 or later