06 July, 2008
"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*").
Posted by Hemant K Chitale at 2:36:00 PM