• I'd check out the new execution plan and figure out what it's doing now. Just so you know in case there are issues in the future. You do have parameters in there so you may see bad parameter sniffing in the future.

    As to why performance changed when you put TOP into the query, that would have changed the choices presented to the optimizer and given you a new plan.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning