Was this helpful?
iiindexes Catalog
Each table with a table_type of I (index) in the iitables table has an entry in iiindexes. In Ingres, all indexes also have an entry in iiphysical_tables.
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.
Last modified date: 04/03/2024