The Significance of Cardinality and Selectivity in Databases

Indexes are an important way of improving database performance and virtually every db has it. Even if you might be tempted, it's usually not that simple to look at the query and slap an index. Most importantly, though, often you have to optimize the ...