On May 13, 2008, at 5:27 PM, Stephen Ince 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.
Query
explain
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.
Query
explain select e.time
from page_view e, page_view d
where
On Tue, May 13, 2008 at 9:27 AM, Stephen Ince [EMAIL PROTECTED] 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