• 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