What are common SQL query optimization techniques?

Key techniques: Use appropriate indexes (check EXPLAIN), avoid SELECT * (retrieve only needed columns), use JOINs over subqueries when possible, limit result sets early (WHERE before JOIN), avoid functions on indexed columns in WHERE, use EXISTS over IN for large datasets, batch operations, use appropriate data types, avoid OR (use UNION instead), leverage query caching. Monitor slow query logs and analyze execution plans regularly.