Post reply

Missing index statistics - Dementia ?

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply