http://www.postgresql.org/docs/8.0/s...s-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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Hi,

At 01:16 28/06/2005, Karl O. Pinc wrote:
>http://www.postgresql.org/docs/8.0/s...s-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