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

Improve shard targeting for $text queries

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Querying, Sharding
    • Labels:
      None
    • Sprint:
      QuInt E (01/11/16), Query F (02/01/16), Query 10 (02/22/16)

      Description

      Currently, sharded $text queries almost always target all shards (i.e. scatter-gather), even if they are AND-related to a simple range scan on the shard key. Instead, $text queries should be targeted using the normal query targeting logic. Special-casing $text queries was previously necessary when planning $text queries on mongos was not allowed, but this restriction was relaxed in the implementation of SERVER-19510.

      The query planner still cannot generate a plan for $text queries without a text index.

        Attachments

          Activity

            People

            Assignee:
            backlog-query-optimization Backlog - Query Optimization
            Reporter:
            rassi J Rassi
            Participants:
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated: