ExportXMLWordPrintableJSON

    • 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.

            Assignee:
            Natalie Hill
            Reporter:
            Junhson Jean-Baptiste
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: