IndexType
Value | Description |
---|---|
P | Nonpartitioned primary index, except if the primary index is also a PRIMARY KEY or UNIQUE, then K or U, respectively, is used for this column |
Q | Partitioned primary index with row, column, or both partitioning, except if the primary index is also a PRIMARY KEY or UNIQUE, then K or U, respectively, is used for this column |
A | Indicates a primary AMP index. |
S | Secondary index, except if the primary index is also a PRIMARY KEY or UNIQUE, then K or U, respectively, is used for this column |
J | Join index |
N | Hash index |
K | Primary key |
U | Unique constraint |
V | Value-ordered secondary index |
H | Hash-ordered ALL covering secondary index |
O | Valued-ordered ALL covering secondary index |
I | Ordering column of a composite secondary index |
1 | Indicates all the columns that comprise the first field of the join index. This value is used for join and hash indexes.
|
2 | Indicates all the columns that comprise the second field of the join index This value is used for join and hash indexes.
|
G | Geospatial nonunique secondary index. |
To determine if a table has partitioning, including when the primary index is for a primary key or unique constraint, see the DBC.TablesV[X].PartitioningLevels column or the DBC.PartitioningConstraintsV[X].PartitioningLevels column.
To determine if a primary-indexed table has partitioning (when the primary index is not for a primary key or unique constraint) view the value of the IndexType column. IndexType is set to P for a nonpartitioned primary index or Q for a partitioned primary index.