Home » RDBMS Server » Performance Tuning » Question about joins
Question about joins [message #284364] Thu, 29 November 2007 08:04 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member

Good Day,

Could u please clarify my doubt may I know what the difference between merge join and hash join? and also There is the way to find the merge join usage in the query .

Because we have run the same query in different two schema it took lot of time in one schema when compare to another one the only difference is merge join and hash join.


- Thank you
Re: Question about joins [message #284366 is a reply to message #284364] Thu, 29 November 2007 08:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

This is not related to sql/plsql section so i moved it to performance tunning.

1. Did you check in documentation about merge join or hash join execution plan ?
go http://tahiti.oracle.com" and search "execution" word .. you will get detail explanation.
Re: Question about joins [message #284377 is a reply to message #284364] Thu, 29 November 2007 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck

Regards
Michel

[Updated on: Sun, 02 December 2007 00:44]

Report message to a moderator

Re: Question about joins [message #284851 is a reply to message #284377] Sat, 01 December 2007 20:09 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
http://people.aapt.net.au/roxsco/tuning/join%20methods.html

Ross Leishman
Previous Topic: Poor Insert Performance after table truncation was interupted
Next Topic: Weird client performance problem
Goto Forum:
  


Current Time: Mon Dec 05 13:06:15 CST 2016

Total time taken to generate the page: 0.09643 seconds