Re: Hash Join vs. Nested Loops

From: Scott David Daniels <Scott.Daniels_at_Acm.Org>
Date: Thu, 27 Feb 2003 19:27:55 -0800
Message-ID: <3e5ed73b$>

Mikito Harakiri wrote:
> The last equation is not correct: my assumption was that we always
> use Indexed Nested Loops. No database goes into production without
> DBA creating join indexes for potentially large tables....
(and then he goes on to describe what I'd call a merge join)

The index provides data structure support for other physical join methods. If you call everything a nested loops join, then nested loops is all you need.

-Scott David Daniels
Scott.Daniels_at_Acm.Org Received on Fri Feb 28 2003 - 04:27:55 CET

Original text of this message