Hi List,

I guess this question was answered already before, however I can't find it anymore.

I was wondering if there is a difference in performance between these 2 statements :

WHERE AFIELD = ID

and

WHERE AFIELD IN (ID)

The field is not indexed.
Sometimes the search criteria contains 1 value and sometimes it can be several values. So I was planning to use 1 SQL construct : IN. So that way it doesn't matter if it is 1 value or several. But I was wondering if IN is slower than =, if the search criteria would contain only 1 value ?

Many thanks in advance,
Nico

[Non-text portions of this message have been removed]