Query optimizer should efficiently handle $in and sort with compound index.

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 2.5.5
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Suppose you have an index on

      {friend_id: 1, date: -1}

      Then, suppose you have a query like this:

      db.things.find({ friend_id: {$in: [lots_of_ids]}}).sort(

      {date: -1}

      ).limit(20)

      Currently, this does a scanAndOrder and scans quite a few documents. Can we optimize?

        1. server3310.js
          0.7 kB

              Assignee:
              hari.khalsa@10gen.com
              Reporter:
              Kyle Banker (Inactive)
              Votes:
              51 Vote for this issue
              Watchers:
              59 Start watching this issue

                Created:
                Updated:
                Resolved: