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

Allow creation of sparse index over a regular index

    • Type: Icon: New Feature New Feature
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.8.1
    • Component/s: Index Maintenance
    • None
    • Storage Execution

      Currently, if you already have a regular index for a given field, there is no way to make it sparse without first deleting the regular index.
      But this is painful when upgrading from 1.6.x, because during the time that the sparse index is being created all your queries that rely on that index become table scans.

      Would be better if there was a way to replace an existing index with a sparse one with no time during which neither index is usable.

            Assignee:
            backlog-server-execution [DO NOT USE] Backlog - Storage Execution Team
            Reporter:
            jeff.yemin@mongodb.com Jeffrey Yemin
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: