SYS.INDEXES

The INDEXES table stores information about the indexes in the data store, including the name, the type (range, bitmap or hash), 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_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen identifier of index.
TBLID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen identifier of indexed table.
IXTYPE	TT_INTEGER NOT NULL	Index type: 0 - hash index 1 - range index 2 - bitmap index
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.
USETMPHEAP	TT_SMALLINT NOT NULL	Reserved for internal use.
KEYCNT	TT_SMALLINT NOT NULL	Number of columns in the index key.
KEYCOLS	BINARY (32) NOT NULL	Array of 2-byte integer column numbers of index key, mapped to binary.
PAGESPARAM	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Number of pages specified for hash index.
NLSSORTID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	For internal use only.
NLSSORTPARM	VARBINARY (1000) NOT INLINE	For internal use only.
NLSSORTSTR	TT_VARCHAR(200) NOT INLINE	For internal use only.
NLSSORTBUF SIZE	TT_SMALLINT	For internal use only.
NLSSORTMAX SIZE	TT_SMALLINT NOT NULL	For internal use only.
HAKANFACTOR	TT_INTEGER NOT NULL	For internal use only.