SAP Knowledge Base Article - Preview

3238693 - EWA - 'Missing index causes expensive SQL statement' Alert on System with HANA DB

Symptom

  • In the EWA, you see a red alert in the Service Summary chapter: Missing index causes expensive SQL statement



  • The alert refers to another EWA chapter Problematic SQL Statements in <SID>, which will specify the missing index(es)
  • The screenshot below is an example of a missing index reported in the EWA, but does not provide clear information on how to resolve it

  • Your managed system uses HANA database

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • Solution Manager 7.2
  • Managed System on HANA database

Keywords

missing index causes expensive sql statement, earlywatch alert, EWA, Solman, Solution Manager , KBA , SV-SMG-SER-EWA , EarlyWatch Alert , HAN-DB-PERF , SAP HANA Database Performance , 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.