-
Type:
Task
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
None
-
None
-
None
-
None
-
None
-
None
-
None
primary code site: https://github.com/10gen/mongo/blob/599ccaadceb3afe90b11b3d9fd10d9bfe8b4aadf/src/mongo/db/commands/query_cmd/analyze_cmd.cpp#L274-L280
Currently, the analyze command only uses the maximum sample size (between CBR's 384 and JOO's 1063) when JOO is globally enabled. This works for now, but the join team is planning to allow enablement of JOO for specific queries via PQS (even when JOO is not globally enabled).
Because of this, we'll need to use JOO's sample size in all cases. Without doing that, queries with JOO enabled (non-globally) will still use CBR's sample size and fall back to on-the-fly sampling
TL;DR: use JOO's sample size in all cases to avoid falling back to on-the-fly sampling whenever JOO is enabled non-globally.
- is depended on by
-
SERVER-138278 Expose join pqs setting for enableJoinOptimization
-
- Open
-
- is related to
-
SERVER-138278 Expose join pqs setting for enableJoinOptimization
-
- Open
-