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

FInd using a boxed match causes full index scan

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Done
    • Icon: Trivial - P5 Trivial - P5
    • None
    • None
    • Querying

    Description

      If I run this find query:

      db.data.findOne({G:/^[W]/})
      

      I get a full index scan being performed.
      explained as :

         "indexBounds" : {
                 "G" : [
                         "[\"\", {})",
                         "[/^[W]/, /^[W]/]"
                 ],
      

      Attachments

        Activity

          People

            sam.kleinman Sam Kleinman (Inactive)
            paul.reed Paul Reed
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: