Incorrect Semi Join Cardinality Estimation - by Paul White NZ

Status : 

 

25
0
Sign in
to vote
ID 906783 Comments
Status Active Workarounds
Type Bug Repros 3
Opened 6/26/2014 8:29:54 AM
Access Restriction Public

Description

Both "old" and "new" cardinality estimators produce an incorrect estimate for an apply semi join with predicates pushed below a union all on the inner side.

The incorrect estimate is a fixed 100% of the input cardinality for the 120 model CE, and 90% for the 70 model.

Full details at http://sqlperformance.com/2014/07/sql-plan/subquery-cardinality-estimation-bug
Sign in to post a comment.