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 -> CBO - Why does it often choose the Sort Merge Join?

CBO - Why does it often choose the Sort Merge Join?

From: Ian <trundlebus1_at_hotmail.com>
Date: 25 Jan 2002 04:03:30 -0800
Message-ID: <f2e963ee.0201250403.17d073b7@posting.google.com> 





Hi,


I've been doing some basic testing on sort/merge and hash joins and
was wondering why the CBO often prefers to use the sort/merge join
rather than the hash join?



I can't find any documentation anywhere!



Many thanks in advance



Si
Received on Fri Jan 25 2002 - 06:03:30 CST












Original text of this message













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