Containment (Simple) vs Containment (base):

Question

Containment (Simple) vs Containment (base):
Containment (Simple): Users query for data that exists. For example, for an equality join between two tables, factor in the predicates selectivity1 in each input histogram, before joining histograms to estimate the join selectivity

Simple Containment becomes Base Containment: Users might query for data that does not exist. For example, for an equality join between two tables, we use the base tables histograms to estimate the join selectivity, and then factor in the predicates selectivity.

still confusing what's the difference . any example ?

Answer 1

Hi,
Also check this if help:
https://www.sqlshack.com/join-containment-assumption-and-ce-model-variation/

Answer 2

So have you read Joe Sack's white paper on the new cardinality estimator yet?
https://learn.microsoft.com/en-us/previous-versions/dn673537(v=msdn.10)?redirectedfrom=MSDN

Answer 3

so it's only applicable to "inner join" , the examples are inner joins