Subject RE: [firebird-support] Table Scans and !=
Author Paul Vinkenoog
Hi Sean,

>> 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?)

Greetings,
Paul Vinkenoog