A new stored procedure, sp_iqindexmetadata, generates a report describing a specified index or indexes belonging to a specified owner or table. For example, the output allows easy checking of whether a given index is a 1-byte or 2-byte default index.
Sybase recommends that if users see “Old One Byte FP” (or “Old Two Byte FP”), they rebuild the default index to leverage the newer, faster index structure. After the rebuild, users see the typical “One Byte FP”.
For details, see “sp_iqindexmetadata procedure” in the Sybase IQ Reference Manual.
