From: Sandro Joel Eller <sandro@tecsoft.com.br>
To: PGSQL <pgsql-sql@postgresql.org>
Subject: Query is slower
Date: Wed, 01 Dec 2004 17:26:59 -0200
Message-ID: <41AE1B03.50205@tecsoft.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sandro@tecsoft.com.br
Subject: Re: Query is slower
In-Reply-To: <41AE1B03.50205@tecsoft.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox