[SERVER-83901] Collscan benchmarks - selectivity Created: 05/Dec/23  Updated: 24/Jan/24  Resolved: 24/Jan/24

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

Type: Task Priority: Major - P3
Reporter: Anton Korshunov Assignee: Henri Nikku
Resolution: Fixed Votes: 0
Labels: M3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-83894 Collscan benchmarks - complex queries... Closed
is depended on by SERVER-84088 Tag new collscan workloads and add th... Closed
Related
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2024-02-05
Participants:

 Description   

Add conjunctive queries, where predicate order matters a lot due to different selectivity of the predicates. This will test the ability of the optimizer to order the predicates according to their selectivity.

We should specifically craft a case where heuristic CE allows us to order the predicates well, and a case where heuristic CE does poorly (for future regression testing).



 Comments   
Comment by Githook User [ 24/Jan/24 ]

Author:

{'name': 'Henri Nikku', 'email': 'henri.nikku@mongodb.com', 'username': 'henrinikku'}

Message: SERVER-83901 Add conjunctive queries having predicates with different selectivities (#1104)
Branch: master
https://github.com/mongodb/genny/commit/54515af8bd5cec61456e319d7638e4a2770af2b2

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