Am Dienstag, den 31.10.2006, 13:04 +0900 schrieb Leif Mortenson:
> Hello,
> I have been having a problem with the following query ignoring an index
> on the foos.bar column.
>
> SELECT c.id
> FROM foos c, bars r
> WHERE r.id != 0
> AND r.modified_time > '2006-10-20 10:00:00.000'
> AND r.modified_t
Leif Mortenson <[EMAIL PROTECTED]> writes:
> Having a column containing large numbers of null or 0 values seems fairly
> common.
You would likely be better off to use NULL as a no-value placeholder,
instead of an arbitrarily chosen regular value (which the planner cannot
be certain does not match
On Oct 31, 2006, at 13:04 , Leif Mortenson wrote:
Hello,
I have been having a problem with the following query ignoring an
index
on the foos.bar column.
SELECT c.id
FROM foos c, bars r
WHERE r.id != 0
AND r.modified_time > '2006-10-20 10:00:00.000'
AND r.modified_time <= '2006-10-30 15:20:0
