Hi,
At 01:16 28/06/2005, Karl O. Pinc wrote:
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?
Not that I know of.
If not, what does this sentence mean?
That you can force the planner to use an index (any one) over not using an
index (and using seq scans instead) by setting enable_seqscan to off.
Jacques.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org