ANALYZE TABLE
ANALYZE TABLE tbl_name[, tbl_name, ...]
This function updates information that’s used by the SELECT query
in the optimization of queries that take advantage of table indices. It pays
in performance to periodically run this query on tables whose contents change
a lot over time. The table(s) in question are locked “read-only”
while the analysis runs.