3327970 - EWA alert for SQL 7a00a013b367f505d7840506e237169e

Symptom

In EWA report, you get "Missing index causes expensive SQL statement" alert for SQL 7a00a013b367f505d7840506e237169e.

SQL string:

SELECT

/* FDA READ */ "INST_HASH" , "INST_HANDLE"

FROM

"LMDB_P_INSTANCE"

WHERE

"DOMAIN_ID" = ? AND "NAMESPACE_ID" = ? AND "VALUE_KIND" = N'P' AND "PQ_HASH" = ? AND "PQ_HANDLE" = ? AND "VALUE" = ? AND

 "CLS_HASH" = ? AND "CLS_HANDLE" = ?

ORDER BY

"LMDB_P_INSTANCE" . "DOMAIN_ID" , "LMDB_P_INSTANCE" . "NAMESPACE_ID" , "LMDB_P_INSTANCE" . "INST_HASH" , "LMDB_P_INSTANCE" . "INST_HANDLE" , "LMDB_P_INSTANCE" . "COUNTER"

Environment

SAP HANA database

Product

SAP HANA, platform edition all versions

Keywords

7a00a013b367f505d7840506e237169e; LMDB_P_INSTANCE; , KBA , 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.