Hi
I have a query using "like" operator (select * from name like 'JOHN%'),
but the table has about 500 hundred records. The has a index (create
index ixcontract_name on contract (name)) , but it is very slow because
it is not using index. How do I do the query to use index?
Sandro
--
*Sandro Joel Eller*
Analista/Programador Senior
www.tecsoft.com.br
sandro@tecsoft.com.br