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.
[ Parent
| on HN ]
There are no comments on this comment yet.