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-5: Indexes supported for data types

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

CMP, HG, LF, TEXT

HNG, 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