SAP Knowledge Base Article - Preview

2712004 - Index advisor asks to create HGi ndex 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 ONE Support launchpad (Login required).

Search for additional results

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