Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan (oracle9i,linux)
Explain plan [message #299260] Mon, 11 February 2008 01:15 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
what is meant by HASH join in explain plan?
Re: Explain plan [message #299262 is a reply to message #299260] Mon, 11 February 2008 01:20 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you try to google for that combination? (hash join and explain)
Lots of usable links there.
Re: Explain plan [message #299263 is a reply to message #299260] Mon, 11 February 2008 01:22 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 13 The Query Optimizer
Section 13.5 Understanding Access Paths for the Query Optimizer
Subsection 13.5.5 Hash Access

Regards
Michel

Previous Topic: date formate problem?
Next Topic: Automatic Refresh of Materialize View
Goto Forum:
  


Current Time: Wed Dec 07 08:29:33 CST 2016

Total time taken to generate the page: 0.11091 seconds