SQL Performance Quick Guide

Making your queries run faster helps your team, your applications, and your users.

In this guide, you'll learn 14 different tactics on how you can improve the performance of your SQL queries, such as:

• removing DISTINCT and finding the real problem
• Using EXISTS instead of IN
• Changing UNION to CASE and simplifying your query
• Changing correlated subqueries to joins
• And much more...

Each tactic includes an explanation, a sample SQL query that shows how to apply the concept, and links to articles/videos/documentation for more details.

The techniques provided can be applied to Oracle, SQL Server, MySQL, and Postgres.