Thursday, June 24, 2010
My favorite parts of today
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?!?
Subscribe to:
Post Comments (Atom)
5 comments:
your daughter is so lovely.
Local big city paper published this one. Stoked my kids no end.
word: dests
Nice one Joel!
No Bugs on the Beach!! :-)
Hello Karen -
In 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
Post a Comment