Just a quick note to say that I found a blog over the weekend with a number of interesting posts, so I thought I’d pass it on: http://www.bobbydurrettdba.com/
There’s a really cute example (complete with test case) of an optimizer bug (possibly only in 11.1) in the December archive: http://www.bobbydurrettdba.com/2012/12/04/index-causes-poor-performance-in-query-that-doesnt-use-it/
Oracle Scratchpad 
Jonathan,
Thank you for mentioning my blog. I’ve learned a ton from your “Cost-Based Oracle Fundamentals” book and from your forum postings and blog. I appreciate your work.
– Bobby
Comment by bobbydurrettdba — January 6, 2013 @ 10:19 pm GMT Jan 6,2013 |