Sybase IQ now supports creating a form of 1-byte default index on fixed-width column data 1 byte wide and a 2-byte default index for columns with fixed-width data 2 bytes wide. This lets the query engine use faster access methods available through the enumerated FP index structure. For details, see “sp_iqrebuildindex procedure” and “MINIMIZE_STORAGE option” in the Sybase IQ Reference Manual.
