Speed

[Guest]

Some one told me that it is faster a query that has a where like this:
where Id=1 or Id=2
instead of
where Id in(1,2)

Is this true?

Thanks a lot, Lina

 

[John Spencer]

I don't believe so unless you are talking milliseconds (or maybe
nano-seconds). As far as I know - my guess- , the
a in (x, y, z)
phrase will be rewritten to be the same as
a = x or a = y or a = z.

The additional time for the processing to rewrite this is going to be
minimal.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks a lot!!

I don't believe so unless you are talking milliseconds (or maybe
nano-seconds). As far as I know - my guess- , the
a in (x, y, z)
phrase will be rewritten to be the same as
a = x or a = y or a = z.

The additional time for the processing to rewrite this is going to be
minimal.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..