What is cardinality in MySQL?

by

Max cardinality: All values are unique

Min cardinality: All values are the same

Some columns are called high-cardinality columns because they have constraints in place (like unique) prohibiting you from putting the same value in every row.

Cardinality is a property which affects the ability to cluster, sort and search data. It is therefore an important measurement for the query planners in DBs, it is a heuristic which they can use to choose the best plans.

More Related Contents:

  1. With MySQL, how can I generate a column containing the record index in a table?
  2. How do I add indexes to MySQL tables?
  3. When should I use a composite index?
  4. Is the primary key automatically indexed in MySQL?
  5. MySQL indexes – what are the best practices?
  6. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  7. How to see indexes for a database or table in MySQL?
  8. Speeding up row counting in MySQL
  9. MySQL varchar index length
  10. What’s the difference between using INDEX vs KEY in MySQL?
  11. Mysql Improve Search Performance with wildcards (%%)
  12. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  13. How do I get MySQL to use an INDEX for view query?
  14. DOs and DONTs for Indexes [closed]
  15. MySQL performance: multiple tables vs. index on single table and partitions
  16. Mysql covering vs composite vs column index
  17. Is there any performance gain in indexing a boolean field?
  18. How to disable index in innodb
  19. Higher cardinality column first in an index when involving a range?
  20. Does Order of Fields of Multi-Column Index in MySQL Matter
  21. MySQL load data infile – acceleration?
  22. Create an index on a huge MySQL production table without table locking
  23. MySQL Integer vs DateTime index
  24. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  25. Can MySQL use multiple indexes for a single query?
  26. MySQL 5.0 indexes – Unique vs Non Unique
  27. How to fix MySql: index column size too large (Laravel migrate)
  28. MySQL optimizing INSERT speed being slowed down because of indices
  29. Would it help to add index to BIGINT column in MySQL?
  30. Mysql performance on 6 million row table

Leave a Comment