Query Optimization and Performance Tips in MySQL

EXPLAIN Example

EXPLAIN SELECT * FROM employees WHERE salary > 50000;

• Use LIMIT with large tables
• Index filter columns
• Avoid subqueries when JOINs are better