Production RiskSoftware ResiliencyCode Reliability
Production Risk
Avoid using “SELECT DISTINCT”, use DELETE-ADJACENT
This code insight ensures for performance reason, if some of the fields are not part of an index, then it is often better to avoid using SELECT DISTINCT.
Why you should care
Business Impacts
CAST recommendations
References
https://technet.microsoft.com/en-us/library/ms187009(v=sql.105).aspx
About CAST and Highlight’s Code Insights
Over the last 25 years, CAST has leveraged unique knowledge on software quality measurement by analyzing thousands of applications and billions of lines of code. Based on this experience and community standards on programming best practices, Highlight implements hundreds of code insights across 15+ technologies to calculate health factors of a software.
See featuresHow it works