Column Name | Data Type | Description |
index_name | char(256) | The index name. Must be a valid name. |
index_owner | char(32) | The index owner. Must be a valid username. |
create_date | char(25) | Creation date of index. This is a date field. |
base_name | char(256) | The base table name. Must be a valid name. |
base_owner | char(32) | The base table owner. Must be a valid username. |
storage_structure | char(16) | The storage structure for the index: heap, hash, isam, or B-tree. Set to blank if unknown. |
is_compressed | char(8) | Y if the table is stored in compressed format, N if the table is uncompressed, blank if unknown. |
unique_rule | char(8) | U if the index is unique, D if duplicate key values are allowed, or blank if unknown. |