Post reply

Execution plan query cost vs Logical Reads

  • January 19, 2011 at 10:19 am

    #243832

    I run 2 queries at the same time with include actual execution plan, and it says query A is taking 3% of the cost, and query B is taking 97% of the cost.

    However, when I look at the statistics. Query A has over 15,000 logical reads on 4 tables. Query B only has 839 logical reads on 2 tables.

    Which query is performing better here?

  • January 19, 2011 at 11:18 am

    #1275461

    duplicate post. No replies, please.

    Continue here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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