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

REPOST: 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: <5$--$%%%_$_$-%$$%$@news.noc.cabal.int>


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

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 06:03:30 CST

Original text of this message

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