[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.

Generated at Thu Feb 08 05:57:33 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.