• Did you know it is possible to create duplicate indexes on one table, both non clustered?

    One will never be used, but will cost in inserts and updates.

    What reason would there be to not immediately delete the unused index?

    If it is not used after 6 months, and statistics are up to date, then only due to irrational fear would they not be deleted.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]