Home » RDBMS Server » Performance Tuning » Reg Hash Join in Performance tunning (toad 9.1 ,oracle 10g)
Reg Hash Join in Performance tunning [message #312168] Tue, 08 April 2008 02:30 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
How for Hash Join concept Work in performance Tuning,pls can any one give a short explanation regarding the above said

Thanks,
Ram
Re: Reg Hash Join in Performance tunning [message #312204 is a reply to message #312168] Tue, 08 April 2008 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you want to know?
How hash join works?

Regards
Michel
Re: Reg Hash Join in Performance tunning [message #312263 is a reply to message #312168] Tue, 08 April 2008 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's a pretty good ( Smile ) presentation of hash join by T. Kyte:
http://asktom.oracle.com/tkyte/hj/hj.html
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:65506569258230

Regards
Michel

[Updated on: Tue, 08 April 2008 05:43]

Report message to a moderator

Re: Reg Hash Join in Performance tunning [message #312267 is a reply to message #312204] Tue, 08 April 2008 05:52 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I need the answer for How hash join works?

Thanks,

Re: Reg Hash Join in Performance tunning [message #312288 is a reply to message #312267] Tue, 08 April 2008 07:42 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See the links I posted.

Regards
Michel
Previous Topic: Performance issue
Next Topic: Two similar queries, two different plans
Goto Forum:
  


Current Time: Fri Dec 09 02:15:31 CST 2016

Total time taken to generate the page: 0.08764 seconds