EXPLAIN Example

EXPLAIN SELECT * FROM employees WHERE salary > 50000;
  • Use LIMIT with large tables
  • Index filter columns
  • Avoid subqueries when JOINs are better