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

FInd using a boxed match causes full index scan

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Trivial - P5
    • Resolution: Works as Designed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Querying
    • Labels:

      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

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

              Dates

              Created:
              Updated:
              Resolved: