The knee-jerk reaction to poor query performance is ‘Create an index!’, but this is not always guaranteed to improve query performance, and in some cases can even damage it. (more…)

Cardinality refers to how many unique values a particular column contains with respect to the number of rows in that table. (more…)