all groups > sql server new users > july 2005 >
You're in the

sql server new users

group:

Executaion plan


Executaion plan Tapi
7/25/2005 12:00:00 AM
sql server new users:
Does anyone know where I could find comprehensive information (on the net)
on how to intepret SQL server's execution plans?
For example:
Hatch Match/Left semi join - Cost: 41%;
Sort/Distinct Sort - Cost:100%;
Merge join/Inner join - Cost: 0%

Thanks in advance

Re: Executaion plan Stu
7/25/2005 9:21:22 AM
http://sql-server-performance.com is a great repository of information;
here's one link to understanding the execution plans (you can search
for others):

http://www.sql-server-performance.com/query_execution_plan_analysis.asp
AddThis Social Bookmark Button