Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the effects of cardinality adjustments. Create efficient SQL queries in low cardinality environments.
Read the whitepaper “Cardinality is not for the birds” to learn more about what data cardinality is, how it affects query plans and performance, and seven heuristics you can use. Trust your SQL engine to make reasonable initial guesses for running database queries. However, to optimize the query performance, it helps to understand data cardinality and indexes. In this whitepaper you will learn:
– How data cardinality can affect query plans and performance.
– How to minimize the effects of cardinality adjustments.
– How to create efficient SQL queries in low cardinality environments.