Why does LINQ fail to optimize across multiple query stages automatically?

LINQ does not perform global query optimization; each operator is evaluated independently by provider.

Unlike database query optimizers that analyze entire execution plans holistically, LINQ builds expression trees incrementally. Providers may optimize final SQL, but LINQ itself does not merge or reorder query stages globally. This limits optimization opportunities such as predicate pushdown across method boundaries.