[SERVER-79602] Consider PathArr simplification for partial index accesses Created: 02/Aug/23  Updated: 03/Aug/23

Status: Open
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Matt Olma Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: bonsai
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Participants:

 Description   

PathArr simplification in Bonsai checks for opportunities to utilize multikey-ness metadata to simplify path requirements. This process requires correct initialization of a pathToInterval function. The default initialization value for this function is an empty function. 

When the function is not explicitly initialized, which when checking for partial index accesses, the optimizer will forego PathArr simplification. 

This ticket should study the importance of this optimization in corner cases and address accordingly.


Generated at Thu Feb 08 06:41:24 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.