Structsยง
- Eliminate
Limit - Merge
Limit - Push
Down Filter ToScan - Attach
Filterpredicates directly to the underlyingTableScan. This lets the physical planner decide whether the scan itself can honor the predicate (e.g. via index) while keeping the logical tree shallower. - Push
Down Limit - Push
Limit Into Scan - Propagate LIMIT/OFFSET requirements into the underlying table scan so that execution can stop scanning early.