MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and Optimizer statistics, not limited to the Histograms only, help increase the speed of the [&]

https://www.percona.com/blog/2019/12/03/webinar-introduction-to-mysql-query-tuning-for-devops/