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: Hash Joins and Sort Merge - When to use?

Re: Hash Joins and Sort Merge - When to use?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 15 Jan 2002 21:40:02 GMT
Message-ID: <3c44a18e.655840297@news.alt.net>


On 15 Jan 2002 10:45:31 -0800, trundlebus1_at_hotmail.com (Ian) wrote:

>Brian,
>
>Thanks for the reply! That site is proving to be very useful.
>
>I have decided to use the Wisconsin data model to create 4 relations -
>2 large and 2 small. I will then join these relations to using Hash
>and Sort Merge, to find which is most efficient when joining a large
>and a small relation or 2 large relations and so on.
>
>Does this kind of comparison sound feasible?
>
>Thanks

I guess so. I am not too experienced, so that much may be better answered by someone else.

Brian Received on Tue Jan 15 2002 - 15:40:02 CST

Original text of this message

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