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

Provide the ability for queries to "hint" and use a particular Query Engine

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:

      Description

      MongoDB version 5.X+ introduced the new Slot Based Execution (SBE) query engine. At the same time, the Classic Query Engine is available as well. This is a feature request to introduce a functionality that will allow users to "hint" and use a particular Query Engine while running a query. The benefits of this will be:

      • It will provide the ability to compare/investigate the performance difference for queries while using either query engine, in real-time.
      • It would make it unnecessary to "switch" the entire query engine (by¬†enabling/disabling SBE) for all the queries, just to compare/investigate the query performance difference with the 2 engines for a small subset of queries.

        Attachments

          Activity

            People

            Assignee:
            backlog-query-execution Backlog - Query Execution
            Reporter:
            harshad.dhavale Harshad Dhavale
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated: