Re: Forcing query to use an index

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Michael Nachbaur <mike(at)nachbaur(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Forcing query to use an index
Date: 2003-03-03 22:09:04
Message-ID: 200303031409.04345.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Michael,

> Unfortunately one stage in the query keeps using a sequence scan rather
> than the index. Here is the "EXPLAIN ANALYZE" results for the 115 line
> SQL query.

If you want any help, you'll need to post the query as well as the explain
results.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-03-03 22:09:35 Re: Forcing query to use an index
Previous Message Greg Stark 2003-03-03 21:29:18 Gist indexes on int arrays