Requires Free Membership to View
Cardinality does not refer to a table, but rather the number of
distinct values of data in a table's column. In a table called
EMPLOYEES, you might have a column called GENDER, which typically has
two values MALE and FEMALE. In this case, the cardinality of the data
in the GENDER column is two. There are two distinct values. In the
same
table, you might have the EMPNO column. Each employee number is a
distinct value. So for 5,000 employees, you will have 5,000
(cardinality) distinct employee numbers. The GENDER column is a low
cardinality column and the EMPNO column is a high cardinality column. This was first published in August 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation