Subject Re: [firebird-support] IN operator performance
Author Nico Callewaert
>> where afield = id
>> if the afield is indexed, the performance is better.
>> where afield in (id)
>> the performance is same (low) with field indexed or not.
>> correct me if i am wrong.

> Sorry, but the optimizer will use an index for IN - both
> formats of IN - list of values and select statement.

> Cheers,

> Ann

Hi again,

I realize performance is better if there's an index on the field, but since the customer can set a filter on every field of the table, that would be useless. I just created indexes for a few important fields. The rest of the fields don't have index...

Best regards !

[Non-text portions of this message have been removed]