Cardinality

In DB2 the cardinality refers to the total number of qualifying rows estimated by the optimizer after filtering operations, such as predicate application or aggregation, are applied. For more information on cardinality check out the Wikipedia link. Cardinality (SQL statements)