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

      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: