Symptom
The performance of the following statement hash is not optimal:
SELECT /* FDA READ */ * FROM "A916" WHERE "MANDT" = ? AND "KAPPL" = ? AND "KSCHL"
= ? AND "DATBI" >= ? AND "DATAB" <= ? AND "VKORG" = ? AND "VTWEG" = ? AND "KDGRP"
= ? AND "ZFIELD" = ? LIMIT 1
The elapsed time of a single execution is in a 10 ms range. In other environments however, runtimes below 1 ms can be observed.
The execution plan is identical in all environments:
| ..LIMIT | NUM RECORDS: 1 |
| ....CPBTREE.INDEX.SEARCH | INDEX NAME: A916~0, INDEX CONDITION: A916.MANDT = '<mandt>' AND A916.KAPPL = '<kappl>' AND A916.KSCHL = '<kschl>' AND A916.VKORG = '<vkorg>' AND A916.VTWEG = '<vtweg>' AND A916.KDGRP = '<kdgrp>' AND A916.ZFIELD = '<ZFIELD>', FILTER CONDITION: A916.DATBI >= '<datefrom>' AND A916.DATAB <= '<datato>
Read more...
Environment
SAP HANA, platform edition 2.0
Product
SAP HANA, platform edition 2.0
Keywords
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.