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 |