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

Disable hash-based index intersection (AND_HASH) by default

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 2.6.5, 2.7.7
    • Querying
    • None

    Description

      Performance testing has suggested that hash-based index intersection, implemented by the AND_HASH query execution stage, does not offer a significant performance advantage for test workloads. This is due in part to SERVER-12923, which describes how query optimization can suffer for plans that are not fully pipelined.

      Based on the results of this testing, we should disable hash-based intersection by default. It will be possible to re-enable AND_HASH at run time via:

      db.adminCommand({setParameter: 1, internalQueryPlannerEnableHashIntersection: 1});

      Sort-based intersection will be on by default and will not be affected by this change.

      Attachments

        Issue Links

          Activity

            People

              david.storch@mongodb.com David Storch
              david.storch@mongodb.com David Storch
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: