SAP Knowledge Base Article - Preview

2543436 - Rebuilding indexes using sp_iqrebuildindex takes a long time - SAP IQ


  • Upgrading to IQ 16.1 from IQ 15.4.
  • Rebuilding indexes using sp_iqrebuildindex takes a long time. For example, for 95G of data it takes around 3.5 hours to sequentially rebuild FP and HG indexes.
  • How to speed up the indexes rebuild process?
  • Can we use parallelism with sp_iqrebuildindex?



  • SAP IQ 16.0
  • SAP IQ 16.1


SAP IQ 16.0 ; SAP IQ 16.1


write, lock, different, multiple, performance, main, space , KBA , BC-SYB-IQ , Sybase IQ , How To

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.