Semantically, there is no difference in the case of Where
(contrast OrderBy
, which needs more care). At the implementation level, it is simply multiple predicates with simple expression trees instead of a single predicate with a complex expression tree; but most engines will cope fine with either.
For what you are doing, multiple Where
is ideal.