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

Ian wrote:
>
> 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

Haven't got hash_join_enabled = false have you? :-)

As a rough guide, if one of the join tables is small, a hash join is often chosen. If both tables are large (and sort_area_size is large), the sort-merges tyically get the nod.

hth
connor

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

http://www.oracledba.co.uk

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