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

Allow pushdown of all eligible SBE stages when $search is pushed down

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • QE 2023-12-25

      SERVER-83685 made "trySbeRestricted" the default knob on master. We allow $search to be pushed down into sbe when "trySbeRestricted" is on, however, we lose out on the benefits of some optimizations when other stages are restricted in SBE with search. Since, search does not use multi planning, it is safe from any slowness from the SBE multiplanner. We should push down all eligible stages to SBE when $search is pushed down to benefit from faster execution and certain optimizations like search + limit. 

            Assignee:
            adi.agrawal@mongodb.com Adi Agrawal
            Reporter:
            adi.agrawal@mongodb.com Adi Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: