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

Index Intersection

    XMLWordPrintableJSON

Details

    Description

      Update:

      Index intersection is on by default. The query planner currently limits itself to 2 indices at a time, though this limit may increase in the future.

      Original Text:

      This should support both single and multiple index intersections.

      This should support queries that which want to use a covered index; then complex intersections would never need to hit the document to return the values.

      A more detailed description of index intersection in a traditional RDMS can be found here:

      http://www.sql-server-performance.com/2003/index-intersection/

      Attachments

        Issue Links

          Activity

            People

              Votes:
              71 Vote for this issue
              Watchers:
              76 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: