Forcing use of a particular index

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Forcing use of a particular index
Date: 2005-06-27 23:16:01
Message-ID: 1119914161l.4428l.4l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl O. Pinc 2005-06-27 23:30:45 Performance analysis of plpgsql code
Previous Message Karl O. Pinc 2005-06-27 23:09:26 Poor index choice -- multiple indexes of the same columns