Efficiency in SQL — Avoid Code With Complex SELECT Clause: Manufacturing Doesn’t Comply In 22% Of Cases

Even beginners in SQL know this best practice: if your application is made of database queries returning too many columns, efficiency (i.e.: response time for end-users) can be dramatically impacted. The infamous SELECT * we all wrote to save our own time…

In CAST Appmarq, while the global compliance to this coding best practice is 82.73%, development teams from the Manufacturing indsutry comply with only 77.93% of possible cases. It looks like customers will have to wait a few seconds more to get their goods built and shipped…

More info & statistics on this quality rule:
https://www.appmarq.com/public/efficiency,7810,Avoid-Artifacts-with-a-Complex-SELECT-Clause

About CAST Appmarq

Appmarq (https://www.appmarq.com) is by far the biggest repository of data about real IT systems. It’s built on thousands of analyzed applications, made of 35 different technologies, by over 300 business organizations across major verticals. It provides IT Leaders with factual key analytics to let them know if their applications are on track.