A new stored procedure, sp_iqrebuildindex, reduces cache usage, reclaims storage space, and improves query performance by rebuilding default indexes into one-byte or two-byte FP indexes. This feature allows you to execute queries during index rebuilds. For details, see “sp_iqrebuildindex procedure” in the Sybase IQ Reference Manual.
