How do you use EXPLAIN statement with an example?

The EXPLAIN statement in MySQL is used to obtain information about how MySQL executes a query. This information can help optimize your SQL queries and improve performance.

Here is a simple example of how to use the EXPLAIN statement:


        EXPLAIN SELECT * FROM employees WHERE department = 'Sales';

In this example, you will receive details about how MySQL plans to execute this query, including information on which indexes will be used, the order of table joins, and the estimated number of rows that will be examined.