Day 5 of Oracle Open World 2011 October 6th
By Maria Colgan on Oct 05, 2011
Its the last day of Oracle Open World and we have saved the very best for last. So hopefully you are still awake and functioning at this stage!
We present our top tip session today at 12 noon in Moscone south, room 104. The session is called Oracle Optimizer: Tips for Preventing Suboptimal Execution Plans (Session 14069). This session is a continuation from a session we did last year called Top Tips for getting optimal SQL execution every time. This year we answers questions like why an index wasn't used, why partition eliminations did not occur, why statistics were ignored, and many more. With clear how-to examples, you will learn to identify and quickly resolve these issues without the need for optimizer hints or initialization parameters.
We hope you have enjoy the conference so far and will stop by our session this afternoon.