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

      Looks like q5 performs worse with join opt enabled than classic. The exchange.ex_ad_id = address.ad_id predicate is mis-estimated at 27k rows when in fact it only returns one.

      May possibly be fixed by enabling internalEnableJoinOptimizationUseIndexUniqueness for this variant- but maybe we should first look at why this estimate is so bad in the first place.

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

              Created:
              Updated: