This list contains the statistics that were created manually or automatically. Columns without statistics do not appear in the list.
Statistic Name
This column provides an identifying name for the statistic. This name is assigned when a new statistic is created.Column
This column provides the name of the column over which this statistic is collected.Partition
This column specifies the partition name.Type
This column provides information on the type of column (for example, INTEGER or CHARACTER, or other column types)Length
This column specifies the number of characters, number of digits, or file size of the value that the function returns.Stale
This column provides a way to determine if the column's statistics are credible. A Yes in this column would indicate that the statistics exist, but that they should be updated.Aging
This column indicates whether the system is responsible for maintaining the statistics for a column or if the user is in control of the statistics collection. Manual indicates that the user decides when to update statistics for a column. Automatic indicates that the system determines when statistics are updated for a column.Requester
This column provides the name of the requester (user profile) that requested statistics to be created or updated. System indicates that the system requested the create or update, while a specific name indicates the user profile of the person who requested the create or update.Translation table
Provides the name of the translation table if one was used for the character columns of the statistics collection. Otherwise, the translation table name will be empty.