• Ignore scan count. It is not the number of times a table has been scanned.

    As for the high logical reads:

    Large table

    No indexes

    Non-optimal execution plan

    Poorly written query

    Poor table design

    Pick any one, or more.

    With no context, no query, no execution plan, no tables, there's no way anyone here can do anything other than guess blindly.

    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