Re: Hash Join vs. Nested Loops

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