Improve index deduplication logic

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • QO 2024-04-01, QO 2024-04-15, QO 2024-04-29, QO 2024-05-13, QO 2024-05-27
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      SERVER-82677 deduplicated indexes in straightforward and safe situations. The requirements were strict, for example if there's a shard key we wouldn't consider deduping. Or if the compared indexes were not plain indexes (not partial/unique/sparse/collated or any type other than btree) we would skip deduplication.

       

      This tickets goal is to improve this logic to deduplicate in more scenarios. We should be careful to only dedup when we know the plans are guaranteed to perform equally well or one strictly worse than the other.

              Assignee:
              Unassigned
              Reporter:
              Matt Boros
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated: