[Join Optimization] Fallback if a single table predicate is rooted $or

XMLWordPrintableJSON

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

      There is currently no implementation of subplanning which works solely with CBR. Our current approach of only performing "whole query planning" and ranking plans with CBR may result in a large regression due to us failing to enumerate the best plan that the subplanner is able to find.

      Until we have a mechanism for single table access planning to handle rooted $or in a cost based manner we should avoid performing join optimization for these queries.

            Assignee:
            Unassigned
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: