Was this helpful?
iistats Catalog
The iistats catalog contains the following information.
Column Name
Data Type
Description
table_name
char(256)
The name of the table. Must be a valid name.
table_owner
char(32)
The table owner. Must be a valid username.
column_name
char(256)
The column name to which the statistics apply. Must be a valid name.
create_date
char(25)
The date on which statistics were gathered. This is a date field.
num_unique
float4
The number of unique values in the column.
rept_factor
float4
The repetition factor, or the inverse of the number of unique values (number of rows/ number of unique values).
has_unique
char(8)
Y if the column has unique values, N otherwise.
pct_nulls
float4
The percentage (fraction of 1.0) of the table which 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(8)
Y if the column contains all possible values in the domain, N otherwise.
stat_version
char(8)
The version of the statistics for this column.
hist_data_length
smallint
The length of the histogram boundary values, either the user-specified length or optimizedb’s computed length.
Last modified date: 01/30/2023