- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
tuning advisor fixated on restructuring
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