Using EXPLAIN

EXPLAIN SELECT * FROM employees WHERE department_id = 2;

Key columns include: type, possible_keys, key, rows, Extra.