[SERVER-68444] Extend Heuristic CE for Sargable node to take into account Traverse Created: 01/Aug/22  Updated: 29/Oct/23  Resolved: 24/Oct/22

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

Type: Task Priority: Major - P3
Reporter: Timour Katchaounov Assignee: Alya Berciu
Resolution: Fixed Votes: 0
Labels: M1
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-67495 Histogram CE for SARGable elemMatch F... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2022-08-22, QO 2022-10-31
Participants:

 Description   

Heuristic CE for SargableNode should be symmetric to the analogous estimates for FilterNode. FilterNode increases selectivity by 10% when the path expression of a condition contains a PathTraverse node because this assumes there may be array data in the path.

This task should do the same for heuristic estimation of SargableNode.

The information about the path is stored inside the key of PartialSchemaRequirements, so should be easy to check.



 Comments   
Comment by Githook User [ 24/Oct/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}

Message: SERVER-68444 Remove added traverse selectivity for FilterNodes
Branch: master
https://github.com/mongodb/mongo/commit/4b485507171554a0c0349d3aa4335cd1a1ba8d47

Comment by Alya Berciu [ 19/Aug/22 ]

This has to wait for the completion of SERVER-67495.

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