Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-72061

[CQF] Allow shared variables between IndexScan intervals

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Won't Fix
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • Query Optimization

    Description

      Because of our interval simplification techniques, there can be a lot of shared information between index scan intervals. Here is the general equation we use for simplifying unioned intervals. We repeat a,b,c,d multiple times between the four bounds. This can result in large plans, for example here

      We would like to factor out these repeated definitions into a "Let", so each index scan can share the definition.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            matt.boros@mongodb.com Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: