I want to know how to yze query execution plan for
complex queries and what information is useful from that
for improving the performance. I have gone through details
in some sites like [url]www.like[/url] sql-performance.com
performance.com/query_execution_plan_ysis.asp), where
it was more generic. I want more info regarding this.

Can any one tell about the resources for this or do you
have any white papers or doents, which you can share
with me.

Thanks in advance,