Re: HASH vs NESTED LOOP join: when is one better than the other ?

From: <mjbox01_at_gmail.com>
Date: 22 Mar 2006 20:07:46 -0800
Message-ID: <1143086866.061970.72510@i40g2000cwc.googlegroups.com>

Spendius wrote:

> When, internally, does Oracle consider that a certain join will give
> better results than the other to join 2 tables ? Can the algorithm be
> simply summarized ?

A Tom Kyte classic

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6643159615303#8047420348035 Received on Wed Mar 22 2006 - 22:07:46 CST

This message: [ Message body ]
Next message: Chintu: "Re: Buffer busy wait clarification"
Previous message: ianal Vista: "Re: many Union all vs. inserting results to temp table"
In reply to: Spendius: "HASH vs NESTED LOOP join: when is one better than the other ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US