/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
By following the instructions of the Index Advisor which recommends adding additional HG indexes.
The new HG indexes created are corrupted at their creation.
The resulting ResultSet is incorrect after creating these new HG recommended indexes
No ERROR/WARNING displayed when creating the indexes.
This appears during the index verification:
================================================== ============================== ======
DBCC Verify Mode Report
================================================== ============================== ======
** DBCC Status Errors Detected ******
================================================== ============================== ======
Index Summary
================================================== ============================== ======
** Inconsistent Index Count 1 ******
Verified Index Count nnn
================================================== ==============================
Read more...
Environment
SAP IQ 16.1 SP05 PL17
Keywords
Corrupt corrupted index indexes indice sp_iqcheckdb creare parallel HG , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)