MySQL SQL optimization explain analysis

explain analysis execution plan You can use the EXPLAIN or DESC command to obtain information about how MySQL executes the SELECT statement, including how tables are connected and the order of connection during the execution of the SELECT statement. Execution plan of query SQL statement: explain select * from tb_item where id = 1;   ...

Posted by xtian on Fri, 01 Oct 2021 20:48:40 +0200