Jun 6, 2008 #1 kermitforney Technical User Joined Mar 15, 2005 Messages 374 Location US Anyone know of a resource online that explains give the explanation and definition of the objects in the execution plan?
Anyone know of a resource online that explains give the explanation and definition of the objects in the execution plan?
Jun 6, 2008 #2 SQLDenis Programmer Joined Oct 1, 2005 Messages 5,575 Location US start here: http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks Upvote 0 Downvote
start here: http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
Jun 6, 2008 Thread starter #3 kermitforney Technical User Joined Mar 15, 2005 Messages 374 Location US Thanks, Denis!! I had no idea the differences between Hash and Merge Joins. Upvote 0 Downvote
Jun 9, 2008 #4 JackVam Programmer Joined Sep 21, 2007 Messages 60 Location GB Also , check SQL Books Online , which gives seome useful information Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com Upvote 0 Downvote
Also , check SQL Books Online , which gives seome useful information Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com