June 24, 2012 at 2:56 pm
How do I know if a join (e.g., INNER, OUTER, etc.) is a star or merge join?
June 25, 2012 at 2:10 am
Ted_Kert (6/24/2012)
How do I know if a join (e.g., INNER, OUTER, etc.) is a star or merge join?
What's your context? If you're attempting to identify Star-join optimisation, then here's a good start.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2012 at 5:06 am
Take a look at the execution plan for the query. When looking at the execution plan, drill down to the properties of the joins and you should be able to find details on how that operation is being done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply