Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan method
Explain plan method [message #314292] Wed, 16 April 2008 05:31 Go to next message
navaneetha
Messages: 5
Registered: April 2008
Location: hyderabad
Junior Member
Hi,
can any one help me how to use explain plan and change the query for increasing the performance and reducing the cost ...
Re: Explain plan method [message #314301 is a reply to message #314292] Wed, 16 April 2008 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: Explain plan method [message #314559 is a reply to message #314301] Thu, 17 April 2008 02:57 Go to previous messageGo to next message
navaneetha
Messages: 5
Registered: April 2008
Location: hyderabad
Junior Member
thks.

but wat r the steps that i shud follow in order to make the query cost less...
Re: Explain plan method [message #314570 is a reply to message #314559] Thu, 17 April 2008 03:23 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Step 1 : Look at the Explained Plan
Step 2 : Think
Step 3 : Fix the things that take long.

(Change the Query / Add Indexes / Change Data Model / hundreds of other possible things.)

"making the query cost less" is not an easy step-by-step process, or else Oracle would have automated it decades ago and build it into the optimizer.
Previous Topic: to extract data
Next Topic: SQL Query: Finding the Sum
Goto Forum:
  


Current Time: Wed Dec 07 02:42:09 CST 2016

Total time taken to generate the page: 0.06889 seconds