Home » RDBMS Server » Performance Tuning » need suggestion on query which performs search on name
need suggestion on query which performs search on name [message #222757] Tue, 06 March 2007 05:41 Go to next message
gkodakalla
Messages: 49
Registered: March 2005
Member
Hi,
we have a table which stores the short names of the customers.
We index that column.
We use order by on few columns in our query.


If the user input for the name on which user is searching is having more than 3 to 4 characters, we get the output quickly (Here i observe the SORT is not happening in explain plna),however if the user inputs only one character (eg: search on "S"), then even though the index is getting used, query takes more time. Here i see the sort option.

Any inputs on how to improve the performance for such cases.
Thanks





Re: need suggestion on query which performs search on name [message #222809 is a reply to message #222757] Tue, 06 March 2007 07:59 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Could you please give us a simplified version of your query and and explain plan result?
And are the statistics up to date?
Previous Topic: saving time in query execution
Next Topic: query hangs
Goto Forum:
  


Current Time: Sun Dec 04 12:26:14 CST 2016

Total time taken to generate the page: 0.06131 seconds