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
Keywords
degraded, slow, , 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.