Get 60% OFF on the Complete Course - MySQL High-Performance Guide Course
https://www.udemy.com/course/mysql-hi...
In this video, we are going to find a couple of reasons, why an index might be useful.
At the same time, we'll see exactly which tables are in need of an index, and which tables are better without one.
Finally, we'll check how MySQL relies on statistics, to choose the best index, and how we can help it to make better decisions.