Every night over dinner my daughter asks me "what was your favorite part of the day Momma"? Well, tonight I had several favorite things to share. My first favorite was that I found an Oracle bug that has to do with subquery factoring (I'm going to blog about this one soon). And my second favorite (well, it's really my *most* favorite) was spending some fun time at the beach with my kiddo. Looks like we had fun doesn't it?!?
your daughter is so lovely.
ReplyDeleteLocal big city paper published this one. Stoked my kids no end.
ReplyDeleteword: dests
Nice one Joel!
ReplyDeleteNo Bugs on the Beach!! :-)
ReplyDeleteHello Karen -
ReplyDeleteIn a reply to a question, Jonathan Lewis referred about an undocumented bug with subquery factoring, whcih you may have discovered earlier (URL: http://jonathanlewis.wordpress.com/2010/09/13/subquery-factoring-4/#comments).
The problem I am facing is, whenever the subquery is materialized the filter does not get pushed down.
I am eagerly waiting for your next post about the relevant details.
BTW, is there a way to tell ORACLE to push the filter before materializing the subquery?
Thanks,
Sharas