title: Does the order of conditions in there where clause affect the speed of the query?
body: <p>Does the order of conditions in there where clause affect the speed of the query?</p>
  
  <p>For instance, could:</p>
  
  <pre><code>select fname, lname 
  from people 
  where isValid = 1 and lname like '%test%'
  </code></pre>
  
  <p>be faster than </p>
  
  <pre><code>select fname, lname 
  from people 
  where lname like '%test%' and isValid = 1
  </code></pre>
  
  <p><strong>Duplicate:</strong> <a href="https://stackoverflow.com/questions/642784/does-the-order-of-columns-in-a-where-clause-matter">Does the order of columns in a WHERE clause matter?</a></p>