The query optimizer has to figure out by itself ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple. Every table that you want ...