[SERVER-67032] Use of columnar indexes should not depend on what subset of SBE is enabled Created: 06/Jun/22  Updated: 09/Feb/23

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

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: pm2646-m5
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Participants:

 Description   

Currently some queries won't use CSI if sbeFull is off and there is no agg pipeline. This includes rooted $or queries with no pushed down $group.

See here. This ticket is to ensure $ors can be run with CSI regardless of sbeFull.



 Comments   
Comment by Ian Boros [ 28/Dec/22 ]

I'm kicking this out to m5 since the set of cases where CSI is not used but sbeFull is on is now just rooted $ors with no $group. The SBE perf project will hopefully enable these queries for SBE by default anyway, in which case this will be a non-issue.

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