Re: block nested loop join
From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Mon, 13 Aug 2001 13:49:26 -0700
Message-ID: <9l9dvk$op4$1_at_stlnews.stl.ibm.com>
Date: Mon, 13 Aug 2001 13:49:26 -0700
Message-ID: <9l9dvk$op4$1_at_stlnews.stl.ibm.com>
Well sounds like another university assignment to me...if not, you need to
clarify your questions a bit.
-Aakash
"soumik" <soumikmandal_at_yahoo.com> wrote in message
news:786dbe5e.0108011247.383916d_at_posting.google.com...
> consider memory buffer contains M blocks.
>
> why in "block nested loop join", M-2 outer-loop blocks are read while
> one inner-loop block is read? what is M-2 inner-loop blocks are read
> and one outer-loop block is read? How does the total # of block
> accesses is minimized for the first case.
> ..... soumik
Received on Mon Aug 13 2001 - 22:49:26 CEST