Physical Join Operators

Speaker(s)Ami Levin

Duration: 60 minutes

Track: Application & Database Development

SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

Accompanying Materials:

No material found.

Back to Top