3 ms·
It depends when you see it, but I agree that DISTINCT shouldn't be used in production. If I'm writing a one off query and DISTINCT gets me over the finish line
by valiant55 1y ago
It depends when you see it, but I agree that DISTINCT shouldn't be used in production. If I'm writing a one off query and DISTINCT gets me over the finish line sparing me a few minutes then that's fine.
- viraptor 1y agoWhich categories did the user post in? Which projects did the user interact with in the last week? That's all normal DISTINCT usage.
- ndsipa_pomu 1y agoThere's nothing wrong with using DISTINCT correctly and it does belong in production. The author is complaining about developers that just put in DISTINCT as a matter of course rather than using it appropriately.