Re: NESTED LOOPS VS. HASH JOINS

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 11 Mar 2002 19:36:18 +0000
Message-ID: <3C8D0732.4FB4@yahoo.com>

Marcelo Parra wrote:
>
> In wich case it is mos convenient to use hash joins and in which others
> nested loops for making a query?
> Txs in advance.

Maybe choose the one which runs best and uses least resources :-)

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Mon Mar 11 2002 - 13:36:18 CST

This message: [ Message body ]
Next message: Charles Dark: "Starting listener in Oracle 9i"
Previous message: Ryan Gaffuri: "Re: How to export D2K reports to Excel?"
In reply to: Marcelo Parra: "NESTED LOOPS VS. HASH JOINS"
Next in thread: Saikat Chakraborty: "Re: NESTED LOOPS VS. HASH JOINS"

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