From: Karl O. Pinc <kop@meme.com>
To: pgsql-performance@postgresql.org
Subject: Forcing use of a particular index
Date: Mon, 27 Jun 2005 23:16:01 +0000
Message-ID: <1119914161l.4428l.4l@mofo> (raw)
http://www.postgresql.org/docs/8.0/static/indexes-examine.html
Says:
"If you do not succeed in adjusting the costs to be more
appropriate, then you may have to resort to forcing index
usage explicitly."
Is there a way to force a query to use a particular index?
If not, what does this sentence mean?
Thanks.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
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-performance@postgresql.org
Cc: kop@meme.com
Subject: Re: Forcing use of a particular index
In-Reply-To: <1119914161l.4428l.4l@mofo>
* 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