Re: Partial Index Usage Performance Question

> > 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