select query optimization [message #351781] |
Fri, 03 October 2008 01:19 |
mdvreddy
Messages: 17 Registered: November 2007 Location: x
|
Junior Member |
|
|
We need to make sure that index should be created and used in select query. for example
select * From emp where ename like '%A%'
In our applications screen,users specify %searchstring% and do searching for record for further operation. they are unhappy because of delay in result. I tried in all the way creation of functional and reverse B* tree indexes but did not find suitable one that accepted by the client. did not find the that ensure that index scan occur rather FTS. help me out. if domain index should be created on this... please explain how and when to do. thanks.
|
|
|