What techniques do you use to optimize database queries, and can you provide an example from your past work?

Technical