Indexing MySQL

Indexes are a crucial part of any database. Many would even say that database performance without indexing is a myth – and that’s not without a reason. Indexes are data structures that facilitate faster access to data by making use of hard drive space in the process; thus, they aren’t exactly revolutionary, but at the same time, the reason why this book has an entire chapter dedicated to keys (keys are a synonym to indexes) is that when used properly, these keys can unlock doors toward the database performance heaven in ways you couldn’t even imagine.