performance of a query [message #223098] |
Wed, 07 March 2007 09:36 |
p.bhaskar
Messages: 33 Registered: February 2007 Location: kolkata
|
Member |
|
|
can any one tell me if i analyze my tables which i use in my select qyery's where clause and get an explain plan for the query do i need any hint further to optimize the query further???
|
|
|
Re: performance of a query [message #223100 is a reply to message #223098] |
Wed, 07 March 2007 09:41 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
It depends.
If you get the result set fast enough, then nothing else needs to be done.
If you do not get the result set fast enough, additional tuning is required.
|
|
|