Re: joint prefetching narrows result set

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Apr 20 2006 - 02:27:30 EDT

  • Next message: Andrus Adamchik: "Re: joint prefetching narrows result set"

    On Apr 20, 2006, at 4:28 AM, Bryan Lewis wrote:

    > Maybe it's common knowledge that one shouldn't specify a joint
    > prefetch
    > on such a relationship? (The old non-joint prefetch with its separate
    > query didn't cause any trouble, of course.) I didn't see this
    > discussed
    > in the user guide. It's not a big deal but I thought I'd mention
    > it in
    > case I'm doing something wrong or it's not common knowledge.

    Bryan,

    It is mentioned briefly in the new docs (last item under prefetching
    hints) -

    http://objectstyle.org/confluence/display/CAYDOC/Prefetching

    This is a totally arbitrary limitation. In the following releases
    we'll add support for the outer joins and this will become a non-issue.

    Andrus



    This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 02:27:59 EDT