Postgres Pro
Downloads
Home   >   mailing lists

Query is slower - Mailing list pgsql-sql

From Sandro Joel Eller
Subject Query is slower
Date
Msg-id 41AE1B03.50205@tecsoft.com.br
Whole thread Raw
Responses Re: Query is slower
Re: Query is slower
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Yudie"
Date:
Subject: Found Large Files.. what objects are they?
Next
From: "Andrew Thorley"
Date:
Subject: Re: inserting values into types