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.