Re: [PERFORM] Forcing use of a particular index

2005-06-27 Thread Jacques Caron
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 part

[PERFORM] Forcing use of a particular index

2005-06-27 Thread Karl O. Pinc
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 m