Query is slower

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