Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan
Explain plan [message #219576] Thu, 15 February 2007 00:47 Go to next message
Messages: 95
Registered: February 2007
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?

Re: Explain plan [message #219579 is a reply to message #219576] Thu, 15 February 2007 00:55 Go to previous message
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 Oct 27 22:18:27 CDT 2016

Total time taken to generate the page: 0.08894 seconds