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 |