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

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

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

      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.

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