Cardinality = product of dimension(ndv) * dimension(selectivity) where selectivity: - is only applied for equality and in predicates.
Cardinality = product of dimension(ndv) * dimension(selectivity) where selectivity: - is only applied for equality and in predicates. - a predicate on a non-gby dimension is assumed not changed the cardinality estmate. - or and not predicates are also assumed not to reduce cardinality.