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

make multikey indices useful for sharding

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor - P4
    • Resolution: Duplicate
    • 2.1.2
    • None
    • Index Maintenance, Sharding
    • None

    Description

      If sharding on "a", an index on "a,b" is not considered useful if there are multikey (array) values for "b". Theoretically, it should still be useful (though maybe less efficient than single-key indices), so we should be able to use it if no single-key index that start with "a" exists.

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-1506 when sharding on a and need an index on a,b allow only a,b index

          • Major - P3 - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. SERVER-9620 Index can be made multikey if a prefix of it is a shard key (splitVectors fail)

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-6493 Inserting array value for non-shard-key field used in prefix shard key index succeeds

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              randolph@mongodb.com Randolph Tan
              matulef Kevin Matulef
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: