Hash join vs NL join [message #264331] |
Mon, 03 September 2007 01:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
beetel
Messages: 96 Registered: April 2007
|
Member |
|
|
When do I use Hash join and when do I use Nested loop join? Is there a criterion in terms of table size, indexes, etc? Please help.
|
|
|
|
Re: Hash join vs NL join [message #264335 is a reply to message #264331] |
Mon, 03 September 2007 01:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You don't use/choose this, Oracle chooses it for you.
If you ask when Oracle choose one or the other one.
Yes, it depends on your query (what you ask), tables size, indexes, area sizes (memory you can use for hash arrays)...
Regards
Michel
[Updated on: Mon, 03 September 2007 01:07] Report message to a moderator
|
|
|
|
|
|
|