| need suggestion on query which performs search on name [message #222757] |
Tue, 06 March 2007 05:41  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
