Column Name | Data Type | Description |
index_name | char(256) | The index name |
index_owner | char(32) | The name of the index owner |
create_date | char(25) | Creation date of index |
base_name | char(256) | The base table name |
base_owner | char(32) | The base table owner |
storage_structure | char(16) | The storage structure for the index: HASH ISAM BTREE RTREE |
is_compressed | char(1) | Y if the table is stored in compressed format N if the table is uncompressed Blank if unknown |
key_is_compressed | char(1) | Y if the table uses key compression N if no key compression Blank if unknown |
unique_rule | char(1) | U if the index is unique D if duplicate key values are allowed Blank if unknown |
unique_scope | char(1) | R if this object is row-level S if statement-level Blank if not applicable |
system_use | char(1) | S if the object is a system object U if user object G if generated by the system for the user Blank if unknown Used by utilities to determine which tables need reloading |
persistent | char(1) | Y if the index re-created after a modify of the table N if not |
index_pagesize | integer | The page size of an index |