Join operators, part 2 - limitations

Question

Join operators, part 2 - limitations

Hugo Kornelis

SSC Guru

Points: 64790
More actions
November 28, 2015 at 2:34 pm

#322558

Comments posted to this topic are about the item Join operators, part 2 - limitations
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
November 29, 2015 at 10:52 pm

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 1

Good question.

A title is misleading a bit. If the question is restricted to joins only, then hash join operator will have two inputs really.

George Vobr SSCrazy Eights Points: 9990 More actions · Answer 2

Again, a well-refined questions, thanks Hugo .. I had burned on statement X.:crying:

Residual Predicate is well explained in:

https://www.simple-talk.com/sql/learn-sql-server/showplan-operator-of-the-week---merge-join/

Ken SSCoach Points: 17191 More actions · Answer 3

Nice question, very informative. I got confused and was thinking hash join and not hash match. Oh well. 🙂

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Good question to make me stop and think. Thanks, Hugo.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 6

Ed Wagner (12/1/2015)
Good question to make me stop and think. Thanks, Hugo.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 7

Thanks for this interesting QOT which proves me that even having spend more than 40 hours to study the operators , I have always a long way up to understand the operators. It is a question I have neglected up to SQL Server 2012 , as I was interested mainly by SMO and T-SQL.

I have reopened an old book ( Inside Microsoft SQL Server 2005 : T-SQL querying ) to see that it was dealing about this topic. I think I will study it and do the same work for the 2008 R2 and 2012 versions before dealing 2014. A long way but I have time enough now.