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
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 Go to previous message
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.
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: Wed Nov 27 01:53:43 CST 2024