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