| Explain plan [message #632329] |
Thu, 29 January 2015 02:07  |
 |
hdba
Messages: 16
Registered: January 2015
Location: INDIA
|
Junior Member |
|
|
Using explain plan how to check performance of query
can you give any good example.
i tried but get confused
|
|
|
|
| Re: Explain plan [message #632330 is a reply to message #632329] |
Thu, 29 January 2015 02:18  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Perhaps posting the query, the plan, all other relevant details, and saying what it is that you find confusing would be a good start.
|
|
|
|
| Re: Explain plan [message #632331 is a reply to message #632329] |
Thu, 29 January 2015 02:18 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
Not really, because you can't check performance based on that.
Query performance come down to one thing - acceptable resource consumption and those resources are: time, IO, memory and CPU cycles.
Most often end users complain about time - if that is the case then you need work out where it is spending its time and fix that. If we are to assist, please post the data in the sticky at the top of this forum. Explain plan alone isn't going to give you this information.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
