INDEXNAME | CHAR | 20 | Name of the index |
TABLENAME | CHAR | 20 | Name of the table on which the
index or hash structure is defined |
OWNER | CHAR | 20 | Owner of the table on which the
index is defined |
UNIQUE | SMALLINT | 2 | Uniqueness indicator:
- 0
if duplicates are allowed, that is, the index is not unique - 1
if duplicates are not allowed, that is the index is unique
|
CLUSTER | SMALLINT | 2 | Clustering indicator:
- 0
if the index is not a clustering index
- 1
if the index is the clustering index for the table
|
NUMC | INTEGER | 4 | Number of columns in the index or hash key |
COLNUMS | BINARY | 64 | A vector of column numbers,
each of type SMALLINT, identifying
the columns the index is defined over.
In ISQL, each SMALLINIT (two-byte) entry is
displayed as a field of 4 hexadecimal digits. |
NPAGES | INTEGER | 4 | Number of index pages containing the index |
NLEVELS | INTEGER | 4 | Number of B-tree levels |
NLEAVES | INTEGER | 4 | Number of B-tree leaf pages |
NDISTINCT | INTEGER | 4 | Number of distinct keys |
NFirst | INTEGER | 4 | Number of distinct First column
values of the B-tree key |
NPERKEY | INTEGER | 4 | Number of pages per B-tree key
|
CCOUNT | INTEGER | 4 | Cluster count; indicates how well the data of the
index is sorted
- 0
before First UPDATE STATISTICS statement is
processed
- n
efficiency of clustering: best clustering if
n=NPATES of table indexed; worst if n=NROWS of
table indexed
|
CTIME | CHAR | 16 | Time of creation: yyyymmddhhsstt |
COLDIRS | BINARY | 64 | A vector of direction entries,
each of type SMALLINT indicating
the direction of the corresponding
column in the index definition.
In ISQL, each SMALLINIT (two-byte) entry is
displayed as a field of 4 hexadecimal digits.
- 5
ASC (Ascending)
- 6
DESC (Descending)
|