Redgate Simple Talk

Database DevOps tools trusted by 92% of the Fortune 100. SQL Server, Oracle, PostgreSQL and more — from schema design and migrations to monitoring and test data.

Popular posts: 1
Total points: 243
HN comments: 170
Rank: #5,234 company

Visit red-gate.com → On Hacker News Oct 2023 – Oct 2023

Software Engineering 1 Databases & Data 1

Most points Most discussed Most cited Newest

Don't use DISTINCT as a "join-fixer"

2023243 points170 comments Databases & Data details

Using DISTINCT to fix duplicate rows from a SQL join is a common antipattern. It generates all the duplicates first, then sorts them away - hurting performance. Learn how to rewrite these queries using EXISTS for cleaner, faster SQL Server results.