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
Source: red-gate.com
Stay updated with breaking news from Selectdistinctc Customer. Get real-time updates on events, politics, business, and more. Visit us for reliable news and exclusive interviews.
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