[SERVER-75715] Parameterize SBE plan cache for clustered collection scans and enable caching Created: 05/Apr/23  Updated: 29/Oct/23  Resolved: 23/May/23

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

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

Issue Links:
Depends
depends on SERVER-74521 Support clustered collections in SBE ... Closed
Documented
Backwards Compatibility: Fully Compatible
Participants:

 Description   

The CollectionScanNode members minRecord and maxRecord are currently not parameterized in the SBE plan cache, therefore initial support for clustered collection scans in SBE (SERVER-74521) had to disable caching of these plans, else when a cached plan gets reused it scans the original range instead of the range specified in the current query.

This ticket is to add SBE plan cache parameterization of these members and enable caching of the plans. The result should be the current query's range bounds get substituted into the cached plan at runtime.



 Comments   
Comment by Githook User [ 23/May/23 ]

Author:

{'name': 'Kevin Cherkauer', 'email': 'kevin.cherkauer@mongodb.com', 'username': 'kevin-cherkauer'}

Message: SERVER-75715 Parameterize SBE plan cache for CC scans and enable caching
Branch: master
https://github.com/mongodb/mongo/commit/49424e5473cf6772db9dec7320dea07c9cc0e4b0

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