Re: Partial Index Usage Performance Question

I can't give you the whole definition because of business reasons. But there are a lot of other columns in T, including a CLOB. Moreover, c is a DATE column, and my condition for c is actually:

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. Received on Tue Oct 07 2008 - 02:14:13 CDT