You have to trust your SQL engine to make reasonable initial guesses for effectively running database queries. However, to optimize the query performance, it helps to understand data cardinality and indexes. In this paper 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