Plan output database Performance degrade
Hi DBA,
the process has low performance by a statement consult the table PRODDDTA.F3111Z1
SELECTÂ *Â FROM PRODDDTA.F3111Z1Â WHEREÂ ( SZEDUS = :KEY1 AND SZEDBT = :KEY2 AND SZEDTN = :KEY3 AND SZEDLN = :KEY4 AND SZUKID = :KEY5 )
the statement Access through fields PK, but has a wrong plan because don't used totally that index, we believe the issue is the NICODE configuration of datasource used by App.
(print attached)
    Â
use partial the index SKIP SCAN (not UNIQUE SCAN) and not colum SZEDUS, SZEDBT y SZEDTN because the App send variables in format NCHAR (not CHAR) the reason is format UNICODE in conection?