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

Consider scanning multikey indices for sorting on arrays and limit:1

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Duplicate
    • Icon: Minor - P4 Minor - P4
    • None
    • None
    • Querying
    • None
    • Query 2019-07-15

    Description

      As a special case to SERVER-40597, a multikey index could be used if the operation includes limit:1.  This optimization may not extend meaningfully for other values applied to the limit.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: