User Guide > User Guide > Working with Databases > Displaying Statistics and Information > Display Statistics
Was this helpful?
Display Statistics
Before you can display statistics, the installation containing the database must be connected in the Instance Explorer (see Connect to an Actian Database Instance).
To display database statistics
1. In the Instance Explorer, right-click the database node and select DBA Utilities, Display Statistics on the context menu.
The Display Statistics dialog appears (see Display Statistics Dialog).
Set options on the General page (see General Page (Display Statistics Dialog)):
1. Select the effective user.
This is the effective user name for the session. Valid only for a privileged user, DBA, or sessions that have the db_admin database permission.
2. Choose whether you want to display statistics only on key and indexed columns.
3. Select whether you want to include all tables or specific tables, or exclude particular tables. Click the Tables button to select or exclude specific tables.
4. If you specified particular tables, choose whether you want to include statistics on all columns or particular columns. Click the Columns button to select specific columns.
5. Choose whether you want to include all indexes or particular indexes. Click the Indexes button to select specific indexes.
Set options on the Options page (see Options Page (Display Statistics Dialog)):
1. Click the Options link in the “Select a page” portlet of the dialog.
The Options page is displayed.
2. Specify any desired options.
Set options on the Display Formatting page (see Display Formatting Page (Display Statistics Dialog)):
1. Click the Display Formatting link in the “Select a page” portlet of the dialog.
The Display Formatting page is displayed.
2. Set any desired character formatting options.
3. Set any desired integer formatting options.
4. Set any desired float formatting options.
Set options on the Output File page (see Output File Page (Display Statistics Dialog)):
1. Click the Output File link in the “Select a page” portlet of the dialog.
The Output File page is displayed.
2. If desired, specify a statistics output file name.
Generate statistics:
1. Click OK.
The Output Log page is shown (see Output Log Page (Display Statistics Dialog)), and statistics are displayed on the text page.
2. Click Close to close the dialog.
Last modified date: 06/06/2024