Jump to content

Cardinality (SQL statements)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 175.29.184.154 (talk) at 09:45, 9 February 2016 (Values of cardinality). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table. The lower the cardinality, the more duplicated elements in a column. Thus, a column with the lowest possible cardinality would have the same value for every row. SQL databases use cardinality to help determine the optimal query plan for a given query.

See also