SAP Knowledge Base Article - Preview

3327117 - Worse than expected performance due to unnecessary FDA WRITE statements

Symptom

In particular scenarios, FDA WRITE statements are slower than expected, even though a very small number of records is returned and the size of the FAE table is quite small. This can be verified for example using the ST05 SQL trace:

------------------------------------------------------------------------------------
Details for Selected SQL Trace Record
------------------------------------------------------------------------------------
   SELECT
     /* FDA WRITE */
     DISTINCT  "V_KNCX_VARC" . *
   FROM
     "V_KNCX_VARC" , ? AS "t_00" ("C_0" NVARCHAR(10), "C_1" NVARCHAR(4), "C_2" NVARCHAR(4))
   WHERE
     "V_KNCX_VARC" . "MANDT" = ? AND "V_KNCX_VARC" . "KUNNR" = "t_00" . "C_0" AND
     "V_KNCX_VARC" . "BUKRS" = "t_00" . "C_1" AND "V_KNCX_VARC" . "GJAHR" = "t_00"
     . "C_2"
------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
Variables
------------------------------------------------------------------------------------
   A0(IT,13)       = ITAB[1x3(36)]
   A1(CH,10)       = 'XXXXXXXXXX'
   A2(CH,4)        = '2201'
   A3(NU,4)        = '2001'
   A4(CH,3)        = '022'
------------------------------------------------------------------------------------


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.