What SQL optimization techniques are you familiar with, and how do they improve query performance?