Speed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
..
 
Thanks a lot!!

John Spencer said:
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
..
Click to expand...
 
Back
Top