July 16, 2002 at 12:00 am
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
July 25, 2002 at 2:48 pm
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
September 22, 2009 at 1:26 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply