SAP Knowledge Base Article - Preview

3307262 - Unexpected runtime for SELECT statements on table A916

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.