-- source: https://www.mysqltutorial.org/mysql-transaction.aspx/
-- 1. disable automatic COMMITs within transactions
-- 2. start a new transaction
EXPLAIN SELECT *; -- your query
ALTER TABLE foo ADD INDEX index_name (a,b,c);
-- EXPLAIN again to see improvements
EXPLAIN SELECT *; -- your query