What does index cardinality measure and why does it matter for query optimization?

Question

SQL Data Analyst — Medium

What does index cardinality measure and why does it matter for query optimization?

Accepted Answer

Index cardinality measures the number of distinct values in an indexed column. High cardinality is important for query optimization because it makes the index more selective and efficient for filtering data.