In MySQL 8.1 and 8.2 we introduced EXPLAIN INTO and EXPLAIN FOR SCHEMA respectively, two extensions to the EXPLAIN query that can help doing most of your query optimization in the server, rather than a client program. These two features lay the groundwork for automatically running multiple EXPLAINs over multiple schemas without having to manually USE each schema or reenter the EXPLAIN output.