On Tue, May 13, 2008 at 9:27 AM, Stephen Ince <since@xxxxxxxxxxxxxx> wrote: > I have to do a multicolumn self-join to find the median. I am using postgres > 8.2. How do I force postgres to use an index scan? I have a multicolumn > index but postgres is not using it. While it's quite acceptable to force index usage during testing, it's a bad idea to do so on a production server unless you have to.
