Index Cardinality

The estimated number of unique values in an indexed column. High cardinality makes an index very selective and effective. MySQL’s SHOW INDEX output shows cardinality, which the optimiser uses to choose between indexes.

← Back to Glossary
Copyright © 2026 Webyog Inc. All Rights Reserved.