How do you identify and optimize slow SQL queries?

Sample answer preview

Identifying and optimizing slow queries requires a systematic approach using tools and techniques. The first step is identifying slow queries. Most databases have a slow query log that records queries exceeding a time threshold.