Re: Partial Index Usage Performance Question
Date: Tue, 14 Oct 2008 08:33:00 -0700 (PDT)
> > SELECT * FROM T WHERE a = ? AND b = ? AND c > t0
> > for some constant date t0, which is known to be older than any value
> > of c in T.
> So if t0 is older than any value in the table your query returns no
> rows, thus it could return MUCH faster than the query which eliminates
> c as a predicate.
That's not right. If t0 is older than any values of c, the condition c
> t0 holds for all rows in T, so the condition is actually redundant.
Received on Tue Oct 14 2008 - 10:33:00 CDT