DEFRECORD KDB_INFO_IDX
KDB table index information| FLD name | Pack format | Purpose |
|---|---|---|
| INFO_IDX_KeyLen | UINT(1) | Index length |
| INFO_IDX_Dups$ | CHAR(1) | Duplicates allowed (ASCII 'N') |
| INFO_IDX_kspec$(_KDB_MAX_KEY_COLS)_KDB_INFO_COL | Index column descriptors | |
| INFO_IDX_nCols | UINT(1) | Number of columns in the key |
| INFO_IDX_kcol(_KDB_MAX_KEY_COLS) | UINT(2) | Index column ordinals |
| INFO_IDX_nCompressCols | UINT(1) | Number of compressed columns at the start of the key |
| INFO_IDX_bVirtual | BOOL | TRUE iff the index is virtual |
| INFO_IDX_bBitmap | BOOL | TRUE iff the index is bitmap |
| INFO_IDX_bGlobal | BOOL | TRUE iff the index is a global non-partitioned index on a partitioned table |
| INFO_IDX_bPrimaryKey | BOOL | TRUE iff the index has a primary key constraint |