Was this helpful?
Display Statistics Dialog
The Display Statistics dialog lets you set options for displaying statistics (see Displaying Statistics and Information). This dialog contains the following pages:
For more information, see Display Statistics.
General Page (Display Statistics Dialog)
This page lets you set basic options for displaying statistics. The following options are available:
Effective User
Specifies the effective user name for the session. Valid only for a privileged user, DBA, or sessions that have the db_admin database privilege.
Some commands, including Backup Database (see Backup Database Dialog), Restore Database (see Restore Database Dialog), Verify Database (see Verify Database Dialog), Create Database (see General Page (New Database)), and Delete Database (see Delete Database Dialog), restrict the use of the effective user option to privileged users.
Note:  This option does not assume the group of the effective user.
Display Statistics on Keys/Indexes Columns Only
Specifies whether to display statistics only on key and indexed columns
Tables
Specifies whether to display statistics for all tables or specific tables. If you select Specify Tables, click the Tables button to choose the tables to include. If you specify particular tables, you may choose to include all columns or select specific columns by clicking the Columns button.
You also may exclude specific tables from statistics display. Click the Tables button to choose the tables to exclude.
Indexes
Lets you choose whether to display statistics on all indexes or specific indexes
Options Page (Display Statistics Dialog)
This page lets you set specific options for displaying statistics. The following options are available:
Wait for Database
Specifies whether to wait until the database has no other open connections before starting to display statistics
Default: Don’t Wait
Display Statistics on System Catalogs
Includes the system catalogs in addition to the base tables
Display Statistics from Composite Histogram on Primary Key
Requests a composite histogram on the primary key structure
Delete Statistics from the System Catalogs
Specifies that statistics already displayed be deleted from the system catalogs
Display Only the Information from iistats
Specifies that only the information contained in the iistats catalog and not the histogram information in iihistograms be displayed
Display Floating-Point Values in Scientific Notation Level
Specifies that floating-point numbers should be read using the precision level specified
Default: 10
Display Cell Values in Hex
Displays histogram cell values in hexadecimal format, which is useful for seeing how Unicode data is stored
Display Formatting Page (Display Statistics Dialog)
This page lets you set formatting options for displaying statistics. The following options are available:
Minimum Character Column Width
Sets the minimum field width for character columns
Default: 6
Minimum Text Column Width
Sets the minimum field width for text columns
Default: 6
Integer Output Width for i1's
Sets the integer output column width for i1’s
Default: 6
Integer Output Width for i2's
Sets the integer output column width for i2’s
Default: 6
Integer Output Width for i4's
Sets the integer output column width for i4’s
Default: 13
Floating-Point Output Width for f4's
Sets the floating-point output column width for f4’s. You must select one of the following output formats:
Floating-Point N (default)
Specifies floating-point format. If numbers are too large for this format, they are displayed in exponential format.
Floating-Point
Specifies floating-point format. If numbers are too large for this format, they are displayed in exponential format, and asterisks (****) are printed to represent display overflow.
Decimal Aligned
Specifies floating-point format with decimal alignment. If numbers are too large for this format, they are displayed in exponential format.
Exponential
Specifies exponential format
You must also set the number fields:
Left number field
Specifies output column width. To prevent column overflow, the left field should be set to the number of the right field + 7.
Default: 10
Right number field
Specifies the number of decimal places in the output
Default: 3
Floating-Point Output Width for f8's
Sets the the floating-point output column width for f8’s. You must select one of the following output formats:
Floating-Point N (default)
Specifies floating-point format. If numbers are too large for this format, they are displayed in exponential format.
Floating-Point
Specifies floating-point format. If numbers are too large for this format, they are displayed in exponential format, and asterisks (****) are printed to represent display overflow.
Decimal Aligned
Specifies floating-point format with decimal alignment. If numbers are too large for this format, they are displayed in exponential format.
Exponential
Specifies exponential format
You must also set the number fields:
Left number field
Specifies output column width. To prevent column overflow, the left field should be set to the number of the right field + 7.
Default: 10
Right number field
Specifies the number of decimal places in the output
Default: 3
Output File Page (Display Statistics Dialog)
This page lets you specify an output file for statistics. The following options are available:
Output Filename
Specifies that the output be written to the specified file instead of to the system catalogs. Click the browse button (…) to navigate to a location.
Output Log Page (Display Statistics Dialog)
The Output Log page displays the output of the process based on the options you have selected on the other dialog pages.
Last modified date: 04/24/2023