SAP Knowledge Base Article - Preview

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

Symptom



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. 




            

         

           
              Read more...
           
        

      



Environment



   

    

  • SAP IQ 16.1
    • 

  • SAP IQ 16.0
    • 








Product



  SAP IQ 16.0 ; SAP IQ 16.1





Keywords



   
 
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 for Me (Login
required).
          
Search for additional results

          
Visit SAP Support Portal's SAP Notes and KBA Search.