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

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-3414 consider using nscannedObjects in addition to nscanned when selecting a query plan

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is depended on by

          Question - SERVER-4572 Geospatial index cannot be used in $and criteria of a query?

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-7742 Improve the way indexes are used to do a range query on one field and sort on another

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-8753 Query optimizer doesn't use hashed key in a query with sorting on a different indexed value

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-3118 get best intersection match via query

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-8768 implement support for interleaving btree and non btree cursors in query optimizer cursor selection code

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-8140 Compound Index with 2d and Text

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-1000 $all with query optimizer

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-9148 In text searches with $near filter, results don't obey filter

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-8790 Introduce composable "stages" in query execution

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: