Re: [SQL] Query is slower

2004-12-01 Thread Michael Fuhr
On Wed, Dec 01, 2004 at 05:26:59PM -0200, Sandro Joel Eller wrote: > 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

Re: [SQL] Query is slower

2004-12-01 Thread Stephan Szabo
On Wed, 1 Dec 2004, Sandro Joel Eller wrote: > 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

[SQL] Query is slower

2004-12-01 Thread Sandro Joel Eller
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