News for hackers. Stuff that matters.
Re:5NF and Database Design by mickeyp on Wednesday April 15, 2026 @07:02AM (#47777392)
I'll go one further and say that if you're reaching for DISTINCT and you have joins, you may have joined the data the wrong way. It's not a RULE, but it's ALWAYS a 'smell' when I see a query that uses DISTINCT to shove away duplicate matches. I always add a comment for the exceptions.

There are no comments on this comment yet.