Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group