• Since indexes are Left Based, the second index is a duplicate.

    The only reason to not remove it is if somebody is using an index hint with the name of this second index.

    Removing it should have no negative impact. But really, you should test in your dev/qa environments first.

    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