SQL Performance (MOSC)

MOSC Banner

Help interpreting SQL Tuning Advisor Recommendation

edited Jan 15, 2015 12:52PM in SQL Performance (MOSC) 1 commentAnswered

Hi,

The advisor is telling me that there is an inequality condition in the query but I cannot find it.

Can you help me to understand?

Do you have any advice to tune this query?

I think that maybe the recommendation refers to:

DECODE(A.ESTATUS,  :"SYS_B_02",:"SYS_B_03",  :"SYS_B_04",:"SYS_B_05",  :"SYS_B_06",:"SYS_B_07", :"SYS_B_08",:"SYS_B_09", :"SYS_B_10",:"SYS_B_11", :"SYS_B_12",:"SYS_B_13", :"SYS_B_14",:"SYS_B_15", :"SYS_B_16",:"SYS_B_17", :"SYS_B_18",:"SYS_B_19", :"SYS_B_20",:"SYS_B_21", :"SYS_B_22",:"SYS_B_23", :"SYS_B_24",:"SYS_B_25",:"SYS_B_26",:"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30" )

Tagged:

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