Column Name | Data Type | Description |
|---|---|---|
table_name | char(256) | The name of the table. |
table_owner | char(32) | The table owner's user name. |
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) | Contains Y if the column has unique values; otherwise, N. |
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 | Identifies the domain from which the column draws its values. |
is_complete | char(1) | Contains Y if the column contains all possible values in its domain, N if the column does not contain all possible values in its domain, or blank if unknown. |
stat_version | char(8) | Version of statistics (for example, ING6.5). |
hist_data_length | smallint | Length of the histogram boundary values. |