Join Elimination: When SQL Server Removes Unnecessary Tables

(Bert Wagner) Join elimination is one of the many techniques that the SQL Server query optimizer uses to create efficient query plans. Specifically, join elimination occurs when SQL Server can establish equality by using query logic or trusted database constraints to eliminate unnecessary joins.