Understanding Execution Plans Part 1

  • Robert W Marda

    SSChampion

    Points: 13413

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Robert W Marda

    SSChampion

    Points: 13413

    That is how I see it. The hash join took longer to run than the inner join. I ran both queries in the same query window and both ran with the same subcost as when run in separate windows. The query cost (relative to the batch) for the inner join was only 31.46% and for the hash join it was 68.54%.

    Robert Marda

    SQL Server will deliver its data any way you want it

    when you give your SQL Programmer enough developing time.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Lawrence M. Meklemburg

    Ten Centuries

    Points: 1217

    Robert,

    In your diagrams, how did you get the yellow information boxes included. Did you just do multiple screen prints and then included them, or did you find some tool to grab them.

    Excellent article, by the way.

    Thanks in advance,

    Larry Meklemburg

    Solon, OH

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

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