Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NESTED LOOPS VS. HASH JOINS

Re: NESTED LOOPS VS. HASH JOINS

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 12 Mar 2002 10:23:29 GMT
Message-ID: <3c8dd6f3.2234926@news-vip.optusnet.com.au> 





Marcelo Parra doodled thusly:



>In wich case it is mos convenient to use hash joins and in which others

>nested loops for making a query?




As Connor already said:  test and use the one that produces the best
results in your particular case.  That's why they are both there: they
aren't mutually exclusive.




Cheers


Nuno Souto


nsouto_at_optushome.com.au.nospam
Received on Tue Mar 12 2002 - 04:23:29 CST












Original text of this message













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