-
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.