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.