title: How to: Manage multiple overlapping indexes in SQL Server 2005
body: <p>For the sake of example, I have a table with columns A B C D E F G H.</p>
  
  <p>I have created two indexes on the table that correspond to the most used queries.  The first is on columns B C D and E.  The second is on B C D E and F.</p>
  
  <p>The queries that use these columns are called the same number of times and they are each optimized with respect to the indexes.  </p>
  
  <p>My issue is - due to the multiple indexes I have on this table, the row size is quite large.  I'd like to remove one of these indexes, but can't decide which one.</p>
  
  <p>My question is - if I remove the first index (BCDE), will a query that uses these columns still be optimized by an index on (BCDEF)?</p>