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
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
long varchar	WD	CMP, 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