Post reply

Keylookup

  • April 3, 2014 at 3:02 am

    #305912

    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

    #1702794

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply