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: 25348
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: Mon Apr 24 14:48:37 CDT 2017

Total time taken to generate the page: 0.11302 seconds