Non Obvious MySQL Index Optimization Tricks part 1

Every developer knows that adding indexes to database tables may speedup database queries. However, in several circumstances, this may not be the case, and your application may actually get slower when you add indexes.

Watch the video of the first part of this talk that teaches what are indexes under the hood, how to determine when you should add indexes to your database tables, when you should not add indexes, and what you can do in alternative to adding indexes when using indexes may slow down your applications.