From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didnt work, but you didnt realize exactly what. Maybe some of you did tests and discovered there was a better execution [&]

https://www.percona.com/blog/2019/10/29/column-histograms-on-percona-server-and-mysql-8-0/