I have experience with MS SQL server where it is possible and useful to update statistic and rebuild indexes I can t find such option in MySQL innoDB is there such option If not how MySQL database create an execution plan Does the MySQL update indexes and statistic with every UPDATE and INSERT

How can I rebuild indexes and update stats in MySQL innoDB?

This is done with

ANALYZE TABLE table_name;