SYS.TINDEXES

The TINDEXES table stores information about the indexes in the temporary table instances associated with active sessions, including the name, the type (range 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's 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 index's table.
IXTYPE	TT_INTEGER NOT NULL	Index type: 0 - hash index. 1 - range 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
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 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.
NLSSORTMAXSIZE	TT_SMALLINT	For internal use only.