Documentation

Optimise a logical plan and lower it to a physical plan.

Rules applied bottom-up (in order): 1. Filter fusion — merge consecutive Filter nodes into a conjunction 2. Predicate pushdown — move Filter past Derive/Project toward Scan 3. Dead column elim — drop Derive nodes whose output is never referenced

After rule application toPhysical selects concrete operators.