tuning advisor fixated on restructuring

User_D2LZA

Hi,

I have a query that performs poorly and picks a plan on some high cardinality values.

I've tried the tuning advisor but it only give restructure advice.

So the query is like

WHERE col = <value> # explain plan shows this is where the issue is

AND decode(blah) = decode (blah) # tuning advisor only mentions this

I don't think the restructure is the issue as we've tried explain plan with various values.

Any advice on how to get tuning advisor to actually tune?

This is version 12.2

Thanks