Was this helpful?
iiindexes Catalog
Each table with a table_type of I in the iitables table has an entry in iiindexes. 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 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.
Last modified date: 04/03/2024