Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan
Explain plan [message #219576] Thu, 15 February 2007 00:47 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hey explain plan is a utility for getting stats?

How to use with a querry to the execution plan for that querry?

To get an execution plan is there any script which we have to run before knowing the execution plan for a particular querry?

Thanks
Re: Explain plan [message #219579 is a reply to message #219576] Thu, 15 February 2007 00:55 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you try to find an answer to these questions yourself? Google, otn.oracle.com and this site are great ways to start a search for explain plan!
Previous Topic: how to set extra number of records
Next Topic: trigger
Goto Forum:
  


Current Time: Thu Dec 08 20:30:07 CST 2016

Total time taken to generate the page: 0.11838 seconds