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 |