How does LINQ optimize chained Where clauses internally?

Chained Where clauses are combined into a single predicate during execution or translation.

Each Where returns a new iterator or expression node. In IQueryable, providers often merge multiple Where calls into a single SQL WHERE clause. In IEnumerable, each Where creates a separate iterator layer, which is executed sequentially. While logically equivalent, performance characteristics differ significantly between in-memory and database execution.