title: In SQL Server, should I create an index for an identity column, or is it created automatically?
body: <p>I believe when I create an <code>identity</code> column it gets indexed automatically, but I'm not 100% sure.</p>
  
  <p>Should I create an index for an <code>identity</code> column, or is it created automatically?</p>