title: Missing Index Details SQL
body: <p>I am tuning my SQL server and when I show my execution plan for one of my queries at the top it reads: </p>
  
  <p>"Missing Index (Impact 99.7782): CREATE NONCLUSTERED INDEX..."</p>
  
  <p>So I looked at the missing index details and it is showing this:</p>
  
  <pre><code>/*
  Missing Index Details from ExecutionPlan1.sqlplan
  The Query Processor estimates that implementing the following index could improve the query cost by 99.7782%.
  */
  
  /*
  USE [phsprod]
  GO
  CREATE NONCLUSTERED INDEX [&lt;Name of Missing Index, sysname,&gt;]
  ON [dbo].[address] ([userid])
  
  GO
  */
  </code></pre>
  
  <p>I have only been working with SQL for about a month now and I have never done anything with this as all my tables have been built for me already.  Can anyone help explain/give me any ideas on what to do with this?  Thanks.</p>