title: SQL2005 indexes
body: <p>Was scanning through a SQL2005 database and saw the following two indexes for a table:</p>
  
  <pre><code>**PK_CLUSTERED_INDEX**
   USER_ID
   COMPANY_ID
   DEPARTMENT_ID
  </code></pre>
  
  <hr>
  
  <pre><code>**NON-unique_NON-clustered_INDEX**
   USER_ID
   COMPANY_ID
  </code></pre>
  
  <p>My initial thought is, drop the last index since the PK_CLUSTERED_INDEX already contains those columns, correct order and sort. Do the last index provide any gains at all?</p>