Fragmentation

SAP 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 that the Main IQ Blocks Used value is less than 100%, it usually indicates that your database is fragmented.