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