Which logical join types can be handled by the Loop Join operator and which can’t? Where does the optimizer have to jump through hoops to generate a query plan? This article gives answers to these questions.
Today’s post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.
This article talks about predicates, probes and residuals, all of which are used in different places of different join queries. This knowledge can help you to identify why your join query is slow and where it is spending its time.
This article introduces the Hash Join algorithm The Hash Join algorithm and shows in which situations it is a good choice. This algorithm is the most CPU and memory intensive one but if you are dealing with large tables it will often also be the fastest.
This article introduces the Sort Merge Join algorithm. It shows its strengths and weaknesses to help you identify query situations for which the Merge Join operator in the execution plan is an appropriate choice.