SAP Knowledge Base Article - Preview

3307262 - Unexpected runtime for SELECT statements on table A916

Symptom

The performance of the following statement 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.