Cardinality

Applies to: sql, general

Cardinality is the number of values or rows in a set. Optimizers use cardinality estimates to choose query plans.

COUNT(DISTINCT user_id)

See also: distinct, index