[SERVER-64305] Use column store for queries with small set of fields but no "lowerable" predicates Created: 07/Mar/22  Updated: 29/Oct/23  Resolved: 07/Apr/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.0.0-rc0

Type: Improvement Priority: Major - P3
Reporter: Charlie Swanson Assignee: Charlie Swanson
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-62985 Change query planner to generate colu... Closed
is depended on by SERVER-64306 Allow partial pushdown of filters int... Closed
Backwards Compatibility: Fully Compatible
Sprint: QE 2022-04-04, QE 2022-03-21, QE 2022-04-18
Participants:

 Description   

Discussed during SERVER-63124. Since we are not competing a column store index vs. a "regular" index at this point, there are probably many cases where this could still be beneficial. We expect this might be slower if you're scanning a large number of columns but we can add a heuristic to allow small # of fields to use the column store.



 Comments   
Comment by Githook User [ 07/Apr/22 ]

Author:

{'name': 'Charlie Swanson', 'email': 'charlie.swanson@mongodb.com', 'username': 'cswanson310'}

Message: SERVER-64305 Use column store index for queries referencing few fields
Branch: master
https://github.com/mongodb/mongo/commit/991ec6b14fa66ee81bc702c0f5e24a1541c6fa05

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