Support persisting NDV for collated/non-btree indexes

ExportXMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      SERVER-134637 added support for hashed/wildcard/collated indices to CBR but explicitly disabled these new index types from using the persisted stats to estimate the NDV.

      They cannot naively use the persisted NDV stats because the index bounds for index scans on these indexes are transformed (hashed/collated/transformed to the wildcard format etc.), which the current persisted NDV stats do not replicate.

            Assignee:
            Unassigned
            Reporter:
            Kartal Kaan Bozdogan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: