ExportXMLWordPrintableJSON

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

      For TPCE locust queries q08/q10/q14/q15/q17 it seems we prioritize a plan with a HJ/NLJ on a COLLSCAN instead of an INLJ probing on the "smaller" table.

      When comparing to classic, the classic plan is (closer) to an INLJ (probing on the small table). While the absolute difference is small (on the order of ~10s of docs) this cost is visible in terms of query latency because each query is very fast.

            Assignee:
            Unassigned
            Reporter:
            Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: