[SERVER-63347] Auto-parameterization of index scan without bounds intersection Created: 07/Feb/22 Updated: 06/Dec/22 Resolved: 31/Mar/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Anton Korshunov | Assignee: | Backlog - Query Optimization |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Optimization
|
| Participants: |
| Description |
|
When we can determined based on a query shape when index intervals evaluation is not required to derive index bounds from the input parameters, we can generate a slightly optimized SBE plan and perform less computations in runtime to generate index bounds. |
| Comments |
| Comment by Anton Korshunov [ 31/Mar/22 ] |
|
There is no intent from the team to implement this ticket. Once we prove that this optimization can bring some performance improvements, we can re-triage it. |