title: Does SQL use both indexes for an AND clause?
body: <p>Suppose query is </p>
  
  <pre><code>select * 
  from tbl 
  where a = 10 and b = 50
  </code></pre>
  
  <p>There are 2 indexes; one for col <code>a</code> and one for col <code>b</code>.</p>
  
  <p>Will SQL Server use both indexes?</p>