SQL Server and the JOIN operators part 1
Hi Guys! Today we start to talk about the JOIN operators! But don’t worry This will be first part because i don’t want bite off more than you can chew Are you ready to learn all about JOIN? Let’s go! Ciao Ragazzi! Oggi iniziamo a parlare degli operatori di JOIN. Non preoccupatevi: l’argomento è vasto ma lo divideremo in più parti per non mettere troppa carne al fuoco. Siete pronti per imparare tutto ma proprio tutto sugli operatori di JOIN? Allora si parte! Introduction First concept: we should know that we have three types of physical join algorithms in SQL Server. They are called hash, nested loops and merge. The Hash Match algorithm is one of the three available algorithms for joining two tables together. However, it is not only about joining. You may observe below a complete list of the logical operations that Hash Match supports in Hash Join Execution Internals. In this article we will focus onto the Hash Match Algorithm. Primo concett...