InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:18:12 GMT20http://www.sqlservercentral.com/Forums/Topic5498-76-1.aspxRobert,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 MeklemburgSolon, OHTue, 22 Sep 2009 13:26:56 GMTLawrence M. Meklemburghttp://www.sqlservercentral.com/Forums/Topic5498-76-1.aspxThat 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 MardaSQL Server will deliver its data any way you want it when you give your SQL Programmer enough developing time.Thu, 25 Jul 2002 14:48:00 GMTRobert W Mardahttp://www.sqlservercentral.com/Forums/Topic5498-76-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp>http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp</A>Tue, 16 Jul 2002 00:00:00 GMTRobert W Marda