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

Make regex indexability a factor of query shapes

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Minor - P4 Minor - P4
    • 4.0.0-rc0
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • Fully Compatible
    • Query 2018-05-21

      The options applied to a regex pattern, such as whether or not it is anchored, impact the query plan that is generated. For example, a left-anchored regex will have tighter index bounds than an unanchored pattern. Such changes yield different performance characteristics.

      The present behavior captures these different characteristics in a single query shape. There may be benefits to using regex options as distinguishing aspects of query shapes.

            Assignee:
            ian.boros@mongodb.com Ian Boros
            Reporter:
            christopher.harris@mongodb.com Chris Harris
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: