Conclusions
•Queries touching old event data
early in the execution plan, then discarding it later in the plan,
tend to indicate poor join orders, or poor join methods (hash joins that
should be nested-loops joins, especially), or non-robust plans
(plans that are only OK because the tables have not grown to
mature size), or poor indexes.