Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| owner | varchar | 128 | √ | null |
|
|
||
| index_name | varchar | 128 | √ | null |
|
|
||
| index_type | varchar | 27 | √ | null |
|
|
||
| table_owner | varchar | 128 | √ | null |
|
|
||
| table_name | varchar | 128 | √ | null |
|
|
||
| table_type | bpchar | 5 | √ | null |
|
|
||
| uniqueness | varchar | 9 | √ | null |
|
|
||
| compression | varchar | 13 | √ | null |
|
|
||
| prefix_length | float8 | 17,17 | √ | null |
|
|
||
| tablespace_name | varchar | 30 | √ | null |
|
|
||
| ini_trans | float8 | 17,17 | √ | null |
|
|
||
| max_trans | float8 | 17,17 | √ | null |
|
|
||
| initial_extent | float8 | 17,17 | √ | null |
|
|
||
| next_extent | float8 | 17,17 | √ | null |
|
|
||
| min_extents | float8 | 17,17 | √ | null |
|
|
||
| max_extents | float8 | 17,17 | √ | null |
|
|
||
| pct_increase | float8 | 17,17 | √ | null |
|
|
||
| pct_threshold | float8 | 17,17 | √ | null |
|
|
||
| include_column | float8 | 17,17 | √ | null |
|
|
||
| freelists | float8 | 17,17 | √ | null |
|
|
||
| freelist_groups | float8 | 17,17 | √ | null |
|
|
||
| pct_free | float8 | 17,17 | √ | null |
|
|
||
| logging | varchar | 3 | √ | null |
|
|
||
| blevel | float8 | 17,17 | √ | null |
|
|
||
| leaf_blocks | float8 | 17,17 | √ | null |
|
|
||
| distinct_keys | float8 | 17,17 | √ | null |
|
|
||
| avg_leaf_blocks_per_key | float8 | 17,17 | √ | null |
|
|
||
| avg_data_blocks_per_key | float8 | 17,17 | √ | null |
|
|
||
| clustering_factor | float8 | 17,17 | √ | null |
|
|
||
| status | varchar | 8 | √ | null |
|
|
||
| num_rows | float8 | 17,17 | √ | null |
|
|
||
| sample_size | float8 | 17,17 | √ | null |
|
|
||
| last_analyzed | timestamp | 22 | √ | null |
|
|
||
| degree | varchar | 40 | √ | null |
|
|
||
| instances | varchar | 40 | √ | null |
|
|
||
| partitioned | varchar | 3 | √ | null |
|
|
||
| temporary | varchar | 1 | √ | null |
|
|
||
| generated | varchar | 1 | √ | null |
|
|
||
| secondary | varchar | 1 | √ | null |
|
|
||
| buffer_pool | varchar | 7 | √ | null |
|
|
||
| flash_cache | varchar | 7 | √ | null |
|
|
||
| cell_flash_cache | varchar | 7 | √ | null |
|
|
||
| user_stats | varchar | 3 | √ | null |
|
|
||
| duration | varchar | 15 | √ | null |
|
|
||
| pct_direct_access | float8 | 17,17 | √ | null |
|
|
||
| ityp_owner | varchar | 128 | √ | null |
|
|
||
| ityp_name | varchar | 128 | √ | null |
|
|
||
| parameters | varchar | 1000 | √ | null |
|
|
||
| global_stats | varchar | 3 | √ | null |
|
|
||
| domidx_status | varchar | 12 | √ | null |
|
|
||
| domidx_opstatus | varchar | 6 | √ | null |
|
|
||
| funcidx_status | varchar | 8 | √ | null |
|
|
||
| join_index | varchar | 3 | √ | null |
|
|
||
| iot_redundant_pkey_elim | varchar | 3 | √ | null |
|
|
||
| dropped | varchar | 3 | √ | null |
|
|
||
| visibility | varchar | 9 | √ | null |
|
|
||
| domidx_management | varchar | 14 | √ | null |
|
|
||
| segment_created | varchar | 3 | √ | null |
|
|
Table contained 0 rows