Home » RDBMS Server » Performance Tuning » performance of a query
performance of a query [message #223098] Wed, 07 March 2007 09:36 Go to next message
Messages: 33
Registered: February 2007
Location: kolkata
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 Go to previous message
Messages: 25525
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.
Previous Topic: Doubt on "SQL Ordered by Parse Calls"
Next Topic: is there any limit for number of connections on a listner port
Goto Forum:

Current Time: Fri Jul 21 16:28:58 CDT 2017

Total time taken to generate the page: 0.56706 seconds