Different query optimizations and how you can use and tune them to get better performance.