ExportXMLWordPrintableJSON

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

      SERVER-134637 is adding support for CE & costing of wildcard/hashed/collated index scans in CBR. That means that automatically these indexes can also be used for single table access plans in JOO. The problem is that our code costIndexScanFragment() is not prepared to cost I/O for any indexes beside BTrees. The options we have:

      1. Modify costing of IXSCAN fragment and give some cost for unknown index types (con: may be wrong)
      1. Use existing IXSCAN fragment IO cost for BTree and use same logic for all index types (con: may be extra wrong, but lowest effort)
      1. Bail at JOO level if there’s a non-BTree index (con: any query on a collection with a wildcard index would bail)
      1. Pass in a filtered set of indexes to single table plan enumerator for single table access paths (i.e. what we do for index probe access path planning)- con: CBR on the same query gives users a different plan, could be a usability problem (Peter Volk suggested it would be here)

      In any case we should do SERVER-133702.

            Assignee:
            Unassigned
            Reporter:
            Max Verbinnen
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: