Understanding Execution Plans Part 1

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Robert Marda » Understanding Execution Plans Part 1

Understanding Execution Plans Part 1

Rate Topic

Display Mode

Topic Options

Author

Message

Robert W Marda

Posted Tuesday, July 16, 2002 12:00 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48

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

Robert W. Marda
SQL Programmer
Ipreo

Post #5498

Robert W Marda

Posted Thursday, July 25, 2002 2:48 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48

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
SQL Programmer
Ipreo

Post #37667

Lawrence M. Meklemburg

Posted Tuesday, September 22, 2009 1:26 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:56 PM
Points: 987, Visits: 124

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

Post #792134

« Prev Topic | Next Topic »

Permissions