When companies report that their data warehouse is under performing, they tend to point at the technology platform: the database, the server, the storage subsystem -- all of these could come in for tight scrutiny.
However, it might not be the technology that's at fault; instead, it could be the SQL (structured query language) code that is causing the problem. Poorly written, inefficient code will cause a query to run far slower than it should.
The quality of the SQL code written by a database professional will determine, to a large extent, the success of their craft. In this article from ITWeb, Alan Raubenheimer, CEO of Embarcadero Africa, analyzes the issue of SQL quality and its impact on companies, and also offers suggestions for ways of improving code quality.
The article continues at
Back to Database Journal Home