3331455 - Query performance degradation due to use of large itabs

Execution of FDA WRITE statements that use an explicit dynamic itab is taking longer than expected. Those statements look similar to the following one:

SELECT
  /* FDA WRITE */
  "<itab>" . "<col1>",
  "<view>" . "<col2>",
  ...
FROM
  ? "<itab>" LEFT OUTER JOIN "<view>" ON ...

The problematic SQL statement exhibits are rather high elapsed time (~8 seconds) from application server point of view in transaction ST05:

AVG_EXECUTION_TIME according to M_SQL_PLAN_CACHE is however significantly lower.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP HANA, platform edition 2.0

KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem