Subject RE: [firebird-support] Query tuning help
Author Paul Vinkenoog
Hi Colin,

Maybe they were just typos, but I've seen this OR clause several times
now in this thread:

>> But what I want is:
>> Where (((Table1.ForeignKey2 >= 962) or (Table1.ForiegnKey2 <= 973))

Don't you mean AND here? I.e.
(Table1.ForeignKey2 between 962 and 973)

Because the OR version, afaict, is the same as
(Table1.ForeignKey2 is not null)

Did you use the OR version for testing?

Paul Vinkenoog