SAP Knowledge Base Article - Preview

2822503 - Feature Request to have a new option for sp_iqrebuildindexwide


Procedure "sp_iqrebuildindexwide" rebuilds pre-16.1 FP indexes wider than 255 bytes. Level option determines how sp_iqrebuildindexwide rebuilds the table or tables. This parameter is optional and includes four options:

1 – rebuilds all pre-16.1 columns wider than 255 bytes for a given user.
2 – rebuilds all tokenized FPs (i.e., pre-16.1 1/2/3 byte FPs, projectable 1 & 2 byte FP, and 16.1 NBit FP) as well as VARCHAR or VARBINARY columns, and all pre-16.1 columns wider than 255 bytes.
3 – rebuilds all fixed Flat FPs, and all pre-16.1 columns wider than 255 bytes.
4 – applies levels 1, 2, 3, and rebuilds all pre- 16.0 columns wider than 255 bytes, all tokenized FPs, all varchar and varbinary columns, and all FLAT fixed FPs

It was suggested to check the possibility of having a new value (for example '5'): Only pre-16.0 version ONLY. That is: Avoid rebuilding version 4 FPs.



  • SAP IQ 16.0 


SAP IQ 16.0


sp_iqrebuildindexwide level option 5 CR 819793 , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.