Question

Explain query optimization using EXPLAIN command​

Answer 1

Answer:

LTE 1 4G Lal 47% 11:43 am The EXPLAIN command provides information about how MySQL executes queries. EXPLAIN can work with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. We'll first analyze the original query, then attempt to optimize the query and look into the optimized query's execution plan to see what changed and why.