Help interpreting SQL Tuning Advisor Recommendation
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" )