Re: what's hash-join

Title: RE: what's hash-join Hi Lisa,   You're correct. I'm sure you know, but I'd like to add that hash join usually works faster than over methods when there are no good selective conditions in the clause WHERE.   Regards, Ed   Hi Kevin, It's quick if you

RE: what's hash-join

The general school of thought is joining a large table to a small one. There is an article on Metalink thats a little out of date now, but it describes the good/the bad, and tuning of hash joins. Look for doc 67134.1 and 41954.1 hth connor --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > What'

Re: what's hash-join

And it will skip partitions that it can see will not match any other corresponding partition. PD Miller wrote: At 0:16 -0800 31/5/01, Senthil Ganapathi wrote: could tell me what's that hash-join  Straight from the concepts manual:  To perform a hash join, Oracle follows these steps:   1. Oracl

RE: what's hash-join

Title: RE: what's hash-join Hi Kevin, It's quick if you have the temp space to support it.  however with larger tables my experience has been that it blows temp, isn't that much faster even if you do have the temp space, and in most cases you are better off with index-driv

RE: what's hash-join

It will perform better than sort and merge and nested loops in most cases. They tend to be fast. But will not out perform index nested loops in most cases. Although in some cases a sort and merge can out perform a hash join. "Walking on water and developing software from a specification are ea

RE: what's hash-join

Kev: How well a HASH join works depends on the data you are working with. In my experience it works best when you are joining a large table against a very small table. I've seen up to 50% improvement when I forced the optimizer to use HASH joins instead of Nested Loops or Merge Joins Kevin ---

RE: what's hash-join

What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match ke

RE: what's hash-join

Huh? Is this jeporady? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Probably a cartesian prod

Re: what's hash-join

A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi <[EMAIL PROTECTED]> wrote: > > Hi Rukmini > could tell me what's that hash-join > > GSK > > > >

Re: what's hash-join

Title: Re: what's hash-join At 0:16 -0800 31/5/01, Senthil Ganapathi wrote: could tell me what's that hash-join Straight from the concepts manual: To perform a hash join, Oracle follows these steps: 1. Oracle performs a full table scan on each of the tables and splits each in

Ang: what's hash-join

Probably a cartesian product Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

what's hash-join

Hi Rukmini could tell me what's that hash-join GSK "Rukmini Devi"To: Multiple