Looking back at the comments audit trail on wordpress I see that I’ve got nearly two months of comments waiting for answers – and some of those answers need serious thought that I haven’t had time to supply yet. But I’ve got a (fairly) free day on Thursday so I’ll see what I can do to bring the comments up to date.
I’ve just had a great day at the Trivadis CBO days – Maria Colgan (the optimizer lady) on the 20th anniversary of the CBO, then Joze Senegacnik on transformations, me on Strategies for Statistics in 11g, ending with Randolf Geist on Parallel Execution (including a reference to one of my older blog items which I now think could well be wrong – so I may have to spend Thursday reviewing it and looking at his analysis instead of working through the comments).
Update 13th Dec
Well, it’s taken me all day – but I seem to have caught up with the comment trail. I’ve probably missed some from the preceding weeks, though, so I’ll be trawling backwards for a little while yet.
I have had time, though, to do a little more work on the parallel query and hash join buffered blog – and it’s very interesting, and I’m definitely wrong, so I’m going to have to prioritise the job of correcting it.
Jonathan,
could you please post the link to your blog entry related to OR NVL expansion ? I asked a question about that today, I cannot find the right article. Thanks.
Stéphane
Comment by sfromholtz — December 11, 2012 @ 8:22 pm UTC Dec 11,2012 |
The initial link (now several years old, in fact) is: http://jonathanlewis.wordpress.com/2007/01/09/conditional-sql/
There are a couple of related follow-up items that you can get to from that page.
Comment by Jonathan Lewis — December 11, 2012 @ 10:47 pm UTC Dec 11,2012 |
Thanks for the link! I’ll do some tests with the few proposed solutions and document this interesting case.
Regards
Stéphane
Comment by sfromholtz — December 11, 2012 @ 11:16 pm UTC Dec 11,2012 |