| Explain plan method [message #314292] |
Wed, 16 April 2008 05:31  |
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 #314570 is a reply to message #314559] |
Thu, 17 April 2008 03:23  |
ThomasG
Messages: 3212
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
