-
Type: Improvement
-
Resolution: Won't Fix
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Distributed Query Planning
-
None
-
Query Optimization
-
QE 2023-02-06, QE 2023-02-20, QE 2023-03-06, QE 2023-03-20, QE 2023-04-03
Read concern level "available" is used to find unowned documents in a sharded cluster. Allowing these queries be targeted to a subset of the shards is counterproductive because it means unowned documents within a particular chunk range cannot be easily searched for.
One workaround is to do an aggregation pipeline with {$replaceWith: "$$ROOT"} as it'll prevent the shard targeting optimization.
- is related to
-
SERVER-76353 Add the ability to force a query to broadcast to all nodes in a replica set and/or all shards in a cluster
- Open