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.

Specifies whether to generate statistics only on key and indexed columns

Specifies whether to generate statistics on 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 generation. Click the Tables button to choose the tables to exclude.

Lets you choose whether to generate statistics on all indexes or specific indexes. If you selected tables to exclude, all indexes are automatically included.

Lets you specify the size of the data set on which to generate statistics. If you select Generate Statistics on Subset of Data, further options become available:

Specifies that information should be printed for each column in the database as it is being processed

Specifies whether to wait until the database has no other open connections before starting to generate statistics

Default: Don’t Wait

Specifies that an exclusive database lock be issued while statistics are generated

Optimizes the system catalogs in addition to the base tables

Requests a composite histogram on the primary key structure

Specifies that statistics should be included for encrypted columns.

For more information about OPTIMIZEDB and data at rest encryption, see the Ingres Security Guide.

Specifies the “fast query” option, which significantly reduces the time to build a histogram. This option improves performance only when the repetition factor of the column is 20 or higher. This option alone generates a global temporary table from the values of the histogrammed columns. The histograms are then built by reading from the faster temporary table, rather than the base table.

When Use 'fast query' to Build Histogram is selected, choosing this option prevents the histogram from being built from a generated global temporary table

Specifies that the histogram generated for each column be printed in the generated statistics

Specifies that the existing repetition factor be used, if any

Disables the default behavior of creating histograms from a maximum 500,000-row sample. Setting this option helps to ensure that all rows are read from a table during the histogram-building process.

Specifies the maximum number of cells that an inexact histogram can contain. In an inexact histogram, each cell represents a range of values.

Default: 200

Range: 2–14999

Specifies the maximum number of cells an exact histogram can contain. In an exact histogram, each cell represents a single unique value.

Default: 200

Range: 1–15000

Indicates whether a column contains all possible values. The range of values in a column affects query optimization. By default, columns are assumed to be incomplete.

Directs optimization to determine only the minimum and maximum values for each column rather than full statistics. Because minimum and maximum values for columns from the same table can be determined by a single scan through the table, this option provides a quick way to generate a minimal set of statistics. Minimal statistics cannot be created on columns holding only null values.

Sets the minimum field width for character columns

Default: 6

Sets the minimum field width for text columns

Default: 6

Sets the integer output column width for i1’s

Default: 6

Sets the integer output column width for i2’s

Default: 6

Sets the integer output column width for i4’s

Default: 13

Sets the floating-point output column width for f4’s. You must select one of the following output formats:

You must also set the number fields:

Sets the the floating-point output column width for f8’s. You must select one of the following output formats:

You must also set the number fields:

Specifies a file name to read statistics from instead of operating directly on the database. The file must be an ASCII-format file that was generated by the STATDUMP command using the ‑o flag.

For more information, see the Ingres Command Reference Guide.

Directs the optimization to read the row and page count values in the Statistics Input file and to store these values in the appropriate system catalog. (You can view these values in iitables.)

Directs the optimization to read floating-point numbers using the specified precision level. To use this option, you must specify a Statistics Input Filename.

Default: 10

Specifies that the output be written to the specified file instead of to the system catalogs

Generates histogram cell values in hexadecimal format, which is useful for seeing how Unicode data is stored