Re: Partial Index Usage Performance Question

From: digory <>
Date: Tue, 7 Oct 2008 00:14:13 -0700 (PDT)
Message-ID: <>

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

Original text of this message