Query optimization techniques include indexing, avoiding unnecessary columns in SELECT statements, using JOINs effectively, and analyzing execution plans to identify performance bottlenecks.