Subject Re: [firebird-support] Table Scans and !=
Author Daniel Rail

At August 4, 2003, 21:35, Paul Vinkenoog wrote:

>>> Is it pretty common knowledge that != on a field always does a
>>> table scan?
>> No!
>> In fact, what does != signify? Not equal?

> Yes, !- means the same in C as <> in Pascal. Both are recognized by
> IB/FB. Kind of weird, actually. (I wonder if both are standard SQL?)

Actually the not equal operator in the SQL standard is <>.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (