Home » RDBMS Server » Performance Tuning » What is hash and nested loop join?
What is hash and nested loop join? [message #65540] Wed, 20 October 2004 04:55 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Dear frends,

I wanted to know the answer of babby question .

What is Hash join and nested loop join and when and how it will be used ?

which one is the best for the optimization for sql query. Is more joins reduce the performance.. is any way to reduce the joins ??

Any help will be the great help for me..

Bhavin

 

Report message to a moderator

Re: What is hash and nested loop join? [message #65541 is a reply to message #65540] Wed, 20 October 2004 09:35 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
If one kind of join were always worse than the other, then the worse one would not exist.

Different joins have different uses in different cases.

Report message to a moderator

Re: What is hash and nested loop join? [message #65547 is a reply to message #65541] Thu, 21 October 2004 05:36 Go to previous message
Padders
Messages: 79
Registered: January 2004
Member
> If one kind of join were always worse than the other, then the worse one would not exist.

Unless of course one was kept for backwards compatibility (or posterity) ;-)

Report message to a moderator

Previous Topic: Scenario : SQL Tuning
Next Topic: Parameters changed in INIT.ora
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:18:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.