SAP Knowledge Base Article - Preview

2712004 - Index advisor asks to create HGi ndex on columns named account_number while it exists -SAP IQ


  • A table has a column named "account_number"
  • Query plans and sp_iqindexadvice advise to create an HG index on that column while an HG already exists.
  • This issue is specific to columns named "account_number".
  • There is no issue with the other columns with different names.

Advise from the query plan
Index Advisor      Add a HG index to grouping column owner.TABLE_NAME.ACCOUNT_NUMBER

sp_iqindex shows that the HG index already exists on the column name "account_number"

 table_name table_owner    column_name index_type       index_name unique_index location dbspace_id remarks
TABLE_NAME    owner ACCOUNT_NUMBER      HG ACCOUNT_NUMBER_HG         N  Main   123456



 SAP IQ 16.0


SAP IQ 16.0


CR817200, CR#817200, 817200, sp_iqindexadvice, sp_iqindex, "query plan", "index advisor", missing index , 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.