Details

      Description

      Query

      I have index on
      db.ogloszenia2.ensureIndex(

      {id:1, x:-1}

      );

      db.ogloszenia2.find({"id":397).limit(200).sort({"x":-1); //use index
      db.ogloszenia2.find({"id":422).limit(200).sort({"x":-1); //use index
      db.ogloszenia2.find({"id":{$in:[397,422]}).limit(200); //use index

      db.ogloszenia2.find({"id":{$in:[397,422]}).limit(200).sort({"x":-1); //does not use index

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                11 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: