Pages

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?!?

5 comments:

  1. Local big city paper published this one. Stoked my kids no end.

    word: dests

    ReplyDelete
  2. 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

    ReplyDelete