|Subject||Re: IN operator performance|
--- In email@example.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.