The terms Data cardinality and Selectivity are quite similar in their operations and many novice SQL developers confuse between these terms. Selectivity can be defined as the ratio between number of rows and cardinality of the table. The selectivity which returns the most post possible rows can be termed as “bad selectivity” whilst the selectivity […]