STATISTICS – Manage Statistics for the Database

This command enables you to manage statistics for a Dimensions CM database.

Syntax:

statistics estimate | compute | delete | sample | instance | table

where:

Parameter | Description
estimate | Estimates statistics for this database.
compute | Computes statistics for this database.
delete | Drops statistics on this database
sample | Generates sample statistics for this database.
instance | Estimate statistics for all databases in this instance.
schema [verbose] | Estimates statistics for the current schema using auto-sampling.
table <table name> | Generate statistics for the specified table in the current schema.

Examples:

statistics table TABLE_NAME [estimate|compute|...]

statistics schema [TABLE_NAME_FILTER [VERBOSE]]