SYS.INDEXES

The INDEXES table stores information about the indexes in the database, including the name, the type, the index key and whether the index is unique.

Columns

Column name	Type	Description
IXNAME	TT_CHAR(31) NOT NULL	Index name
IXOWNER	TT_CHAR(31) NOT NULL	Name of index owner
IXID	TT_BIGINT NOT NULL	TimesTen identifier of index
TBLID	TT_BIGINT NOT NULL	TimesTen identifier of indexed table
IXTYPE	TT_INTEGER NOT NULL	Index type 0 - hash index 1 - range index (t-tree) 3 - range index (b-tree)
ISUNIQUE	BINARY(1) NOT NULL	Uniqueness 0 - nonunique index 1 - unique index
ISPRIMARY	BINARY(1) NOT NULL	Primary key 0 - not a primary key for table 1 - primary key for table
ISGLOBAL	BINARY(1) NOT NULL	Global or local index 0 - local 1 - global
USETMPHEAP	TT_SMALLINT NOT NULL	Internal use
KEYCNT	TT_SMALLINT NOT NULL	Number of columns in the index key
KEYCOLS	BINARY(64) NOT NULL	Array of two-byte integer column numbers of index key, mapped to binary
PAGESPARAM	TT_BIGINT NOT NULL	Number of pages specified for hash index
NLSSORTID	TT_INTEGER NOT NULL	Internal use only
NLSSORTPARM	VARBINARY(1000) NOT INLINE	Internal use only
NLSSORTSTR	TT_VARCHAR(200) NOT INLINE	Internal use only
NLSSORTBUFSIZE	TT_SMALLINT	Internal use only
NLSSORTMAXSIZE	TT_SMALLINT	Internal use only
HAKANFACTOR	TT_INTEGER NOT NULL	Internal use only
GLOBALIXMVID	TT_BIGINT NOT NULL	Internal materialized view ID for the global index