A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iistats Catalog
 
Share this page                  
iistats Catalog
Th iistats catalog contains entries for columns that have statistics.
Column Name
Data Type
Description
table_name
char(256)
The name of the table
table_owner
char(32)
The owner of the table
column_name
char(256)
The column name to which the statistics apply
create_date
char(25)
The date on which statistics were gathered
num_unique
float4
The number of unique values in the column
rept_factor
float4
The repetition factor
has_unique
char(1)
Y if the column has unique values
N if the column is not unique
pct_nulls
float4
The percentage (fraction of 1.0) of the table that contains NULL for the column
num_cells
smallint
The number of cells in the histogram
column_domain
smallint
A user-specified number signifying the domain from which the column draws its values; default is 0
is_complete
char(1)
Y if the column contains all possible values in the domain
N if the column does not contain all possible values in the domain
stat_version
char(8)
The version of the statistics for this column, for example, II9.0
hist_data_length
smallint
The length of the histogram boundary values:
Either the specified length
Or length computed by optimizedb