Home » SQL & PL/SQL » SQL & PL/SQL » eplainplan
eplainplan [message #9252] Wed, 29 October 2003 06:51 Go to next message
saravanan kbk
Messages: 3
Registered: October 2003
Junior Member
please give me the purpose of the explainplan?
where it is used and how can i use that?

saravanan kbk.
Re: eplainplan [message #9253 is a reply to message #9252] Wed, 29 October 2003 08:04 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Explain plan gives you the execution plan choosen by the Oracle optimiser for a given sql statement.There are many many ways of executing a particular query or say a delete operation, and depending upon your optimizer settings and presence/absence of object statistics Oracle uses either Rule based optimizer(until 9i) or Cost based optimizer to device the most efficient(atleast thats what the goal is) execution plan and proceeeds to execute the query.

There are tons of examples on this site of where and how it is used. You can use EXPLAIN (to get the execution plan without executing the statement itself) or sqlplus AUTOTRACE or TKPROF etc etc to get the execution plan..

one example using autotrace -->

Previous Topic: Mutating table problem (from trigger)
Next Topic: cannot use pctincrease in create table statement
Goto Forum:
  


Current Time: Thu Mar 28 08:41:14 CDT 2024