SQL Optimizer for SAP ASE 3.9 - Release Notes

Right Pane for Tables Analyzed

In the Index Usage Analyzer window, when the Tables Analyzed is selected in the left pane, the following information displays in the right pane.

Summary button

Provides a summary of the use of indexes for each table. It gives the total number of SQL that use the table and if the SQL statement accesses the table with a full table scan or uses an index to access the table.

Chart button

Charts the number of SQL statements that use the table.

Related Topic

Index Usage Analyzer Window