To view these statistics, use Administration & Maintenance | Database Statistics from the context menu, or use the Database Statistics node in the Database Navigator.
Note:
| · | Retrieving the statistics might take some time, especially on larger databases
|
| · | This functionality only works with InterBase SuperServer, version 6 or higher
|
Database Workbench will show you the statistics in both textual form and an "analyzed" grid-form. The grid form is much easier to read and groups index statistics per table. It also allows sorting of the values, ascending/descending, by clicking on the headers of the grid columns.
Analyzed Statistics
You can save and load the statistics by using the Open From File and Save To File buttons. Loaded statistics (a plain text file) will be analyzed and available in grid-form after loading.