Mimer SQL on Windows
Mimer SQL on Windows > DbAnalyzer Utility > DbAnalyzer Statistics
DbAnalyzer Statistics

This DbAnalyzer view displays information about actual usage of constraints and indexes. It is used on a running system to see the effectiveness of the available search paths. The following information is displayed:

Heading Description
Schema Name The name of the schema where the object is located.
Object Name Name of the table, constraint, or index.
Type The object type, such as TABLE, UNIQUE, FOREIGN KEY, or INDEX:
Usecount The number of active SQL statements that actually reference the index is shown here.

It is possible to select Refresh from the view menu to clear the window and show a new set of statistics.

See Also