Symptom
Executing a query produces a result set with n rows.
Index Advisor recommends creating some HG indexes.
After creating these new HG recommended indexes, the result count differs: n+x rows.
No ERROR/WARNING displayed when creating the indexes.
Read more...
Environment
SAP IQ 16.1 SP05 PL16
Product
SAP IQ all versions
Keywords
different resultset result set index hg sp_iqcheckdb tzable index indexes indice , 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.
SAP Knowledge Base Article - Preview