When indexing a column, choose only supported index types for the column data type.
The default index allows any data type.
Data Type | Supported Indexes | Unsupported Indexes |
---|---|---|
tinyint | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
smallint | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
int | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
unsigned int | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
bigint | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
unsigned bigint | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
numeric, decimal | CMP, HG, HNG, LF | WD, DATE, TIME, DTTM, TEXT |
double | LF (HG permitted but not recommended) | CMP, HNG, WD, DATE, TIME, DTTM, TEXT |
float | LF (HG permitted but not recommended) | CMP, HNG, WD, DATE, TIME, DTTM, TEXT |
real | LF (HG permitted but not recommended) | CMP, HNG, WD, DATE, TIME, DTTM, TEXT |
bit | (Default index only) | CMP, HG, HNG, LF, WD, DATE, TIME, DTTM, TEXT |
date | CMP, HG, HNG, LF, DATE | WD, TIME, DTTM, TEXT |
time | CMP, HG, HNG, LF, TIME | WD, DATE, DTTM, TEXT |
datetime, timestamp | CMP, HG, HNG, LF, DTTM | WD, DATE, TIME, TEXT |
char <= 255 bytes, character | CMP, HG, HNG, LF, WD, TEXT | DATE, TIME, DTTM |
char >255 bytes | CMP, WD, TEXT | HG, HNG, LF, DATE, TIME, DTTM |
varchar <= 255 bytes | CMP, HG, HNG, LF, WD, TEXT | DATE, TIME, DTTM |
varchar >255 bytes | CMP, WD, TEXT | HG, HNG, LF, DATE, TIME, DTTM |
long varchar | WD, TEXT | CMP, HG, HNG, LF, DATE, TIME, DTTM |
binary <= 255 bytes | CMP, HG, LF, TEXT | HNG, WD, DATE, TIME, DTTM |
binary > 255 bytes | CMP, TEXT | HG, HNG, LF, WD, DATE, TIME, DTTM |
varbinary <= 255 bytes | CMP, HG, LF, TEXT | HNG, WD, DATE, TIME, DTTM |
varbinary > 255 bytes | CMP, TEXT | HG, HNG, LF, WD, DATE, TIME, DTTM |