View previous topic :: View next topic
|
Author |
Message |
pranav08
New User
Joined: 05 Sep 2010 Posts: 10 Location: noida
|
|
|
|
I have a query that uses a join, it's running pretty slow. Please suggest how I can improve the performance. Is there any way to find out the cost and CPU time needed of the query? |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
There are many tools in market to help you out with CPU time for individual Query of program
For checking why your SQL running slow, Please EXPLAIN in spufi
For more information on EXPLAIN please google |
|
Back to top |
|
|
|