Attach the table definitions and actual execution plan (not estimated).
The key lookup means you do not have a covering index for the query. You need to create a covering index for the query to eliminate the key lookup.
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