Subject Re: [firebird-support] IN operator performance
Author Ann W. Harrison
Fernando Medeiros wrote:
> 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.