Tag Info

New answers tagged

2

I don't know of a way to trace all the plans the optimizer considers. Obviously the EXPLAIN statement gives you the plan the optimizer eventually selects (and the re-written statement), but that doesn't tell you anything about the ones it doesn't select. One way to get a little more info might be to set CURRENT QUERY OPTIMIZATION to different values (the ...


2

Yes! This is called a 10053 trace in Oracle parlance. It's more formally known as "Tracing of Optimizer Computations". Check out MOS doc 225598.1, or Jonathon Lewis' blog post here: https://jonathanlewis.wordpress.com/2014/05/23/10053-trace/ There's loads of hits for "10053 trace" so if you can't find what you need, it's probably out there in search-land. ...



Top 50 recent answers are included