SYS.TINDEXES
The TINDEXES
table stores information about the indexes for temporary tables 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 |
---|---|---|
|
|
Index name |
|
|
Name of index owner |
|
|
TimesTen identifier of index |
|
|
TimesTen identifier of index's table |
|
|
Index type 0 - hash index 1 - range index |
|
|
Uniqueness 0 - nonunique index 1 - unique index |
|
|
Primary key 0 - not a primary key for table 1 - primary key for table |
|
|
Global or local index 0 - local 1 - global |
|
|
Internal use only |
|
|
Number of columns in the index key |
|
|
Array of two-byte integer column numbers of index key, mapped to binary |
|
|
Number of pages specified for hash index |
|
|
Internal use only |
|
|
Internal use only |
|
|
Internal use only |
|
|
Internal use only |
|
|
Internal use only |
|
|
Internal use only |
|
|
Internal materialized view ID for the index |