Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When does a merge join beat a hash join?
2 : A fairly sweeping statment - don't know the size of the inputs or what they look like therefore can't answer the question
3: Probably Mr. Lewis is the man to answer this one...
"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message
news:tjeb6vk2brd93jtbuopirauuset9g2vimq_at_4ax.com...
> A general (theoretical? academical?) question:
>
> When the Oracle optimizer chooses a merge join, why doesn't it choose
> a hash join instead?
> Shouldn't a hash join always be faster than a merge join?
> And if it isn't, is that because of poorly chosen parameter values, or
> are there data situations in which it is inherent that a merge join is
> faster than a hash join?
>
> Jaap.
Received on Wed Mar 05 2003 - 04:53:54 CST