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

SQL Data Analyst Hard

SQL Data Analyst — Hard

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

Key points

  • High cardinality means more unique values in the column
  • Selectivity increases with high cardinality
  • Efficient indexes lead to faster query performance

Ready to go further?

Start full exam Practice more questions

Related questions