ABOUT JOIN FAST

The still left JOIN is simple to clarify: A cross product of all entries from all other entries is designed. The circumstances on the join (inside your case: just take all entries over the still left and discover fitting kinds on the right) are used Later on. I labored on all SQL Server variations (2008, 2008R2, 2012, 2014 and 2016). I really like