MySQL :: How to run ANALYZE TABLE for all tables in a database

10 votes

5 answers

21990 views

                          I'm using MySQL 5.7

How can I run ANALYZE TABLE for all tables in a database. It should work if new tables are added to the database in future.

This is to refresh the statistics of table indexes.

Asked by Satish Gadhave (203 rep)

Apr 4, 2020, 06:41 PM
Last activity: Aug 16, 2021, 06:51 PM

MySQL :: How to run ANALYZE TABLE for all tables in a database

Related Questions