SAP Knowledge Base Article - Preview

2597483 - sp_iqrowdensity always return 1, while indexes could be fragmented - SAP IQ 


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 page

This 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.