Column Name | Data Type | Description |
|---|---|---|
index_name | char(256) | The index name. Must be a valid object name. |
index_owner | char(32) | The index owner's user name. |
create_date | char(25) | Creation date of index. |
base_name | char(256) | The base table name. Must be a valid object name. |
base_owner | char(32) | The base table owner. Must be a valid user name. |
storage_structure | char(16) | The storage structure for the index: heap, hash, isam, or btree. |
is_compressed | char(1) | Contains Y if the table is stored in compressed format, N if the table is uncompressed, or blank if unknown. |
key_is_compressed | char(1) | Contains Y if the table uses key compression, N if not, or blank if unknown. |
unique_rule | char(1) | Contains U if the index is unique, D if duplicate key values are allowed, or blank if unknown. |
unique_scope | char(1) | Contains S if uniqueness is checked after completion of queries or R if uniqueness is checked after each row is modified or inserted. |
system_use | char(1) | Contains S if the index was created by the DBMS, U if created by a user, or blank if unknown. (The Ingres DBMS creates unique indexes to enforce unique constraints on tables.) |
persistent | char(1) | Contains Y if the index is retained when its base table is modified (using the Ingres modify statement), or N if the index is dropped when the table is modified. |
index_pagesize | integer | The page size of an index. |