title: Why does SQL Server 2005 Dynamic Management View report a missing index when it is not?
body: <p>I'm using SQL Server 2005 and the the Dynamic Management View <code>sys.dm_db_missing_index_details</code>. It continues to tell me that Table1 really needs an index on ColumnX and ColumnY, but that index already exists! I've even dropped and re-created it a couple times to no avail.</p>
  
  <p>More specifics: The view lists Column1 under <code>equality_columns</code>.  Column2 is listed under <code>inequality_columns</code>, so the index I have created is:</p>
  
  <pre><code>create index IndexA on Table1 (Column1 asc, Column2 asc)
  </code></pre>
  
  <p>Isn't this exactly the index <code>sys.dm_db_missing_index_details</code> is telling me I need?</p>