Data types in the index

The default index allows any data type. See the following table for a list of other indexes supported for each data type.

Table 6-4: Indexes supported for data types

Data type

Supported indexes

Unsupported indexes

tinyint

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

smallint

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

int

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

unsigned int

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

bigint

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

unsigned bigint

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

numeric, decimal

CMP, HG, HNG, LF

WD, DATE, TIME, DTTM

double

LF (HG permitted but not recommended)

CMP, HNG, WD, DATE, TIME, DTTM

float

LF (HG permitted but not recommended)

CMP, HNG, WD, DATE, TIME, DTTM

real

LF (HG permitted but not recommended)

CMP, HNG, WD, DATE, TIME, DTTM

bit

(Default index only)

CMP, HG, HNG, LF, WD, DATE, TIME, DTTM

date

CMP, HG, HNG, LF, DATE

WD, TIME, DTTM

time

CMP, HG, HNG, LF, TIME

WD, DATE, DTTM

datetime, timestamp

CMP, HG, HNG, LF, DTTM

WD, DATE, TIME

char <= 255 bytes, character

CMP, HG, HNG, LF, WD

DATE, TIME, DTTM

char >255 bytes

CMP, WD

HG, HNG,LF, DATE, TIME, DTTM

varchar <= 255 bytes

CMP, HG, HNG, LF, WD

DATE, TIME, DTTM

varchar >255 bytes

CMP, WD

HG, HNG, LF, DATE, TIME, DTTM

binary

CMP, HG, LF

HNG, WD, DATE, TIME, DTTM

varbinary <= 255 bytes

CMP, HG, LF

HNG, WD, DATE, TIME, DTTM

varbinary > 255 bytes

CMP

HG, HNG, LF, WD, DATE, TIME, DTTM