Explain MySQL query optimization techniques.

Optimization techniques:
• Use appropriate indexes
• Avoid SELECT *
• Use LIMIT for large datasets
• Optimize WHERE clauses
• Use EXPLAIN to analyze queries
• Normalize database design
• Use connection pooling

Example:
EXPLAIN SELECT name FROM users WHERE email = 'john@example.com';
-- Shows execution plan and index usage