title: Multiple Indexes vs Multi-Column Indexes
body: <p>What is the difference between creating one index across multiple columns versus creating multiple indexes, one <em>per</em> column?</p>
  <p>Are there reasons why one should be used over the other?</p>
  <p>For example:</p>
  <pre><code>Create NonClustered Index IX_IndexName On TableName
  (Column1 Asc, Column2 Asc, Column3 Asc)
  </code></pre>
  <p>Versus:</p>
  <pre><code>Create NonClustered Index IX_IndexName1 On TableName
  (Column1 Asc)
  
  Create NonClustered Index IX_IndexName2 On TableName
  (Column2 Asc)
  
  Create NonClustered Index IX_IndexName3 On TableName
  (Column3 Asc)
  </code></pre>