Re: NESTED LOOPS VS. HASH JOINS

Hi,
What I had noticed that hash join is more effective when: 1. The resultset data volume is large. In fact the larger the data volume, the more effective is the hash join. 2. Of the two tables that are joined, one is of less volume compared to the other.

Nested loop is effective when the resultset is very small. Of course to use Hash joins, you need to have CBO.

Thanks,
Saikat
http://saikatchak.tripod.com

"Marcelo Parra" <marcelop_at_pidcgroup.com> wrote in message news:a6iu4v$s1c$1_at_newsreader.mailgate.org...

> In wich case it is mos convenient to use hash joins and in which others
> nested loops for making a query?
> Txs in advance.

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG