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"
Read more...
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.