--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> 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.
>
> Cheers,
>
> Ann
>