sp_iqrowdensity always returns 1 for NBit indexes although the NBit indexes could be fragmented.
If you check the initial table size with sp_iqtablesize and if you create a new table and populate it with the data from the initial table,
and run sp_iqtablesize on the new table, you could see the new table's size could shrink quite a lot, although both tables contain the same data.
This shows that there is fragmentation in the initial table.
- SAP IQ 16.1
- SAP IQ 16.0
SAP IQ 16.0 ; SAP IQ 16.1
CR813154, CR#813154, 813154, fragmentation, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.