In this article author will discuss secondary indexes common mistakes and bad practices. While the article is focused on MySQL and the InnoDB storage engine, most of this information applies to any DBMS. Published by Federico Razzoli.
An index is an ordered data structure.
Common mistakes and bad practices
- Duplicate indexes
- Indexes and the primary key
- Expecting the impossible
- Columns order
- UNIQUE indexes
- Index names
Indexes are essential for query performance. And fast queries are essential for application performance. Interesting read!
[Read More]