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. |