Missing index statistics - Dementia ?

• Query Shepherd

  SSCrazy

  Points: 2988

  More actions

  March 11, 2013 at 9:58 am

  #275103

  I use a script showing me the missing index statistics with impact and so on. I think you all know it. But sometimes I add an index which is costly, cleanup the statistics. And he shows me the index again? Why this? IS this a bug? Can somebody explain me this? Getting into details would be nice ;).

  PS: I know the impact is not a good indicator, but what is the reason for this behaviour?

  Greetz
  Query Shepherd

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 11, 2013 at 10:37 am

  #1595662

  Sometimes you may continue to see that index because the query that needs it has columns using a different sort order than the index. And sometimes it is a bug.

  First check the sort for the columns and see if that is impacting the index use.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 12, 2013 at 5:31 am

  #1595914

  The bug.[/url]

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato