Post reply

why is it doing key look up even after creating a covering index?

  • October 25, 2012 at 5:12 pm

    #284047

    I will try to post the execution plan,i have section of execution plan where it is doing a Key Lookup along with a index seek. In the index seek the output list is Code,Id and seek is on logid. In the Key lookup seek is on Id. I created a covering index on logid,id and have code in included section. Logid is bigint,id is bigint and code is nvarchar(1000). Even after creating this index i still see it is doing a key lookup( though it utilizing the new index in index seek). Am i missing something here?

  • October 25, 2012 at 5:14 pm

    #1552987

    Query, index definition and exec plan please. Without those, impossible to say anything useful.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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