Don’t use DISTINCT as a “join-fixer”

I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.

How Many Distinct Records

SQL DISTINCT on Multiple Columns

Learn the basic usage of DISTINCT in this article.