• Read this link and then post the execution plan

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    The missing indexes being recommend by the execution plan are probably not covering indexes but we can't tell that if we can't see the plan.

    We would also need to see some scripts for the tables involved.

    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