"Table Elimination" (aka "Join Elimination")

The Optimizer Group's blog posting on the Table Elimination transformation is certainly worth reading. This is a useful feature (although it can leave some DBA's scratching their heads wondering why a t able doesn't appear in the Execution Plan when it "*should*").