From: David Siebert <david@eclipsecat.com>
To: pgsql-general@postgresql.org
Subject: Yet another indexing issue.
Date: Tue, 19 Mar 2002 13:40:51 -0500
Message-ID: <OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com> (raw)
In-Reply-To: <20020315101751.N51975-100000@megazone23.bigpanda.com>
I am having issues with an Index.
Here is the query
SELECT * FROM phonecalls WHERE istatus = 0 AND (sfor = 'pat' OR
sfor='TECHIES') ORDER BY ipri DESC, dplaceddate;
I have tried '0' and jut plain 0 as well as type casting it with ::int4 .
Here is the index I think it should use.
CREATE INDEX phonecallspoll ON phonecalls USING btree (sfor varchar_ops,
istatus int4_ops);
But it is still doing a scan?
Any suggestions?
yes I have used Vacumme with the anylise option.
Thanks for any info.
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: david@eclipsecat.com, pgsql-general@postgresql.org
Subject: Re: Yet another indexing issue.
In-Reply-To: <OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com>
* 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