Query is slower

From: Sandro Joel Eller <sandro(at)tecsoft(dot)com(dot)br>
To: PGSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Query is slower
Date: 2004-12-01 19:26:59
Message-ID: 41AE1B03.50205@tecsoft.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)tecsoft(dot)com(dot)br

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2004-12-01 20:09:40 Re: Found Large Files.. what objects are they?
Previous Message Yudie 2004-12-01 18:07:20 Found Large Files.. what objects are they?