Forum Stats

  • 3,825,755 Users
  • 2,260,558 Discussions
  • 7,896,660 Comments

Discussions

tuning advisor fixated on restructuring

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