Day 5 of Oracle Open World 2011 October 6th

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.


Maria Colgan+

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The Oracle Optimizer blog is written by members of the Optimizer development team. The goal of this blog is to provide an insight into the workings of the Optimizer and the statistics it relies on. The views expressed on this blog are our own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect ours.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today