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

Ability to temporarily forbid query optimizer from using index ("invisible index")

    XMLWordPrintableJSON

Details

    • Query
    • Fully Compatible
    • v4.4
    • Query 2018-03-12, Query 2018-03-26, Execution Team 2020-03-09, Execution Team 2020-03-23
    • 88

    Description

      It would be helpful if there was a way to disable an index before dropping. Been clearing out some unused production indexes lately, but there's always a tense moment after issuing the dropIndex command where I wait to see if it was less "unused" than expected.

      If there was a way to just disable the index (semantics would be that it keeps getting updated, just can't be used by queries), then a revert would be much faster if something goes wrong and the drop could be done with more confidence.

      Attachments

        Issue Links

          Activity

            People

              backlog-server-query Backlog - Query Team (Inactive)
              adamaflynn Adam Flynn
              Votes:
              9 Vote for this issue
              Watchers:
              32 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: