Dear experts,
We faced performance problem with t-code FAGLL03.
So, I implemented a note 1464365.
This note add DB6 hint statement in Fucntion Module FAGL_GET_ITEMS_BSIS and FAGL_GET_ITEMS_BSAS source code.
OPEN CURSOR WITH HOLD I_CURSOR FOR
select (lT_FLDLIST_S)
from (ld_dbtab_syntax) CLIENT SPECIFIED
where (lt_where_tab)
%_HINTS DB6 '+[%FROM BSIS % INNER JOIN FAGLFLEXA]' <<<<<<
DB6 '<REOPT VALUE=''ONCE'' />' .
After implementing it, I can not see access plan about a specific SQL statement with t-code ST04.
Things like this happen in joining two tables, BSIS(BSAS) and FAGLFLEXA in Fucntion Module FAGL_GET_ITEMS_BSIS(BSAS).
We use a DB2 v9.5.
I don't see why this happen.
Do you know anyone who can explain this issue?
Thanks.
Lee
Edited by: Ki-Uk Lee on Jan 17, 2012 1:03 AM