title: Clustered and nonclustered index large data insert
body: <p>I had a clustered index on 5 keys (columns). I had an unclustered index on 2 columns. Because I'm inserting 2-3 million rows in one run, I changed the 2 column unclustered index to clustered and changed the 5 column clustered index to 5 column unclustered index. My question.</p>
  
  <ol>
  <li><p>When making an index clustered (basically delete and recreate the index as <code>clustered</code>), I don't need the <code>include</code> (any columns) right since this is clustered?</p></li>
  <li><p>Is it generally correct that I switch the less column index into clustered and change the large column clustered index to unclustered? In other words, clustered index should be simple and small?</p></li>
  <li><p>Is there any performance issues if I switch these two indexes?</p></li>
  </ol>