Kjell Rilbe wrote:

>
>> Since the
>>beginning of (its) InterBase / Firebird have _not_ used
>>indexes with _NOT_ conditions. Whether (or _not_) that's
>>appropriate with expressions like NOT NULL is debatable.


> This is yet another example of all those peculiarities you have to be
> aware of when using Firebird.
>

Perhaps a quiet suggestion to the devel list that for the next
version, the rule about the selectivity of NOT should consider
the condition being negated...

Regards,


Ann