[SERVER-83441] Pushdown top-level fields from FilterNode into PhysicalScanNode Created: 20/Nov/23 Updated: 11/Jan/24 Resolved: 21/Dec/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.3.0-rc0 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Anton Korshunov | Assignee: | Timour Katchaounov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | M7 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||
| Sprint: | QO 2023-11-27, QO 2023-12-11, QO 2023-12-25 | ||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Linked BF Score: | 35 | ||||||||||||||||||||||||
| Description |
|
Currently this optimization is supported on a Sargable node. In order to be able to skip the Filter->Sargable rewrite we should be able to push-down top-level fields directly from a Filter node into a Scan node. |
| Comments |
| Comment by Githook User [ 20/Dec/23 ] |
|
Author: {'name': 'Timour Katchaounov', 'email': '34627040+timourk@users.noreply.github.com', 'username': 'timourk'}Message:
Push top-level PathGet as a PhysicalScan projection. Implemented via path analysis inside the implementor transport for The transformation is performed only for FilterNodes that are directly GitOrigin-RevId: 32cba0c99ac4d8e758068be6a724c0a6bc2d1ab0 |