- 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"
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 pageThis 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.