|Subject||Re: [firebird-support] IN operator performance|
>> where afield = idHi again,
>> 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.
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]