[PERFORM] Forcing use of a particular index

[Karl O. Pinc]

http://www.postgresql.org/docs/8.0/static/indexes-examine.html

Advertising

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 <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED])