Post reply

How to avoid Keylookup

  • June 5, 2013 at 3:55 am

    #273504

    Hi,

    SELECT L.ClaimSummaryUID,

    L.ClaimLineUID,

    L.ChargedAmount,

    L.PaidAmount,

    L.RevenueCode

    FROM dbo.#Cancels A

    INNER JOIN ClientDB.dbo.ClaimLine AS L

    ON L.ClaimSummaryUID = A.ClaimUID

    Above metioned is the code which i need to run. For this code am getting the attached execution plan.

    How to avoid Keylookup. Kindly advice on this.

    Regards,

    Karthik.

    Regards,
    Karthik.
    SQL Developer.

  • June 5, 2013 at 4:11 am

    #1621259

    Would advice you to run tuning advisor and analyse the index it returns..

    or see if below suggestion resolves key lookup.

    Include below columns in index [HumanaAuditClaims].[dbo].[ClaimLine].[idx_ClaimLine_ClaimSummaryUID]

    [HumanaAuditClaims].[dbo].[ClaimLine].ClaimLineUID, [HumanaAuditClaims].[dbo].[ClaimLine].ChargedAmount, [HumanaAuditClaims].[dbo].[ClaimLine].PaidAmount, [HumanaAuditClaims].[dbo].[ClaimLine].RevenueCode

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

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

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