[SERVER-79451] [CQF] Investigate support for special indexes under $natural hint Created: 28/Jul/23  Updated: 29/Oct/23  Resolved: 14/Aug/23

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

Type: Task Priority: Major - P3
Reporter: Militsa Sotirova Assignee: Militsa Sotirova
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-08-07, QO 2023-08-21
Participants:

 Description   

SERVER-78994 changed the fallback such that we run queries against collections with non-special indexes through CQF if the query has a $natural hint. This ticket tracks the investigation of whether we want to extend this to special indexes. The work would likely include building metadata (IndexDefinition, MultikeynessTrie) for special indexes.



 Comments   
Comment by Githook User [ 14/Aug/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-79451 Support queries against collections with special indexes, except hashed, to go through CQF under natural hint
Branch: master
https://github.com/mongodb/mongo/commit/f0d9da7c9a3e112a1dff43d20f2ab046cbc2bfa4

Comment by Militsa Sotirova [ 31/Jul/23 ]

As discussed during standup, changing the metadata structures to support special indexes would require much more design than is in scope for this ticket, so this ticket will capture the work to just allow these special indexes through CQF, but not use their metadata.

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