Fragmentation

Sybase IQ provides control over fragmentation by taking advantage of even the smallest unused spaces.

However, fragmentation can still occur. If your database runs out of space, even though Mem Usage listed by sp_iqstatus or theĀ .iqmsg file shows Main IQ Blocks Used is less than 100%, it usually indicates that your database is fragmented,