CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Plan output database Performance degrade

edited Sep 2, 2016 5:00AM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center