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

Exclude indexes from query plan (hint_only: true)

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Querying
    • None
    • Query Optimization

    Description

      I am using certain array compound indexes which are quite heavy. I've seen cases where these can slow down the query plan selection on queries where we do not intended to be used. (We call this the "Mongo Index Butterfly Effect".)

      It would be very nice to be able to define something like "hint_only: true" on the index itself to prevent it from being used EXCEPT when it has been explicitly hinted.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            johnnyshields Johnny Shields
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated: