I'm relatively new to MS SQL. Does MS SQL "short-circuit" boolean expression? The reason I ask this is to speed up my query, so that when 1 condition is fulfilled, the other needs not be evaluated at all. Simplified example of the query is given in snippet.
For a record whose column1 is 100, will MS SQL still evaluate column2 = 200?
In my actual query, the 2nd condition is more complex
Preferrably, if you have a reference to MS documentation that explain this, it would even be better.
Many thanks in advance!
column1 = 100 AND
column2 = 200