SAP Knowledge Base Article - Preview

2712004 - Index advisor asks to create HG index on columns named account number while it exists -SAP IQ

Symptom

  • 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


Read more...

Environment

 SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

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

Search for additional results

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