April 3, 2014 at 3:02 am
Good Day. I executed a query and in its execution plan I saw a Keylookup and in the output I noticed an entry called chk0001. Non of the tables in the database has such a table . How can we go about to resolve this keylookp ? Should we rather ask the DEV team to rewrite the query ?
Regards.
Lian
April 3, 2014 at 4:35 am
Hard to tell for sure what's going on without seeing the execution plan. Chk001 sounds like a column derived somewhere else within the plan. A key lookup suggests that you might need a covering index, but again, without seeing the plan, that's just vague speculation.
"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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply