Improving Maintenance and Performance of SQL queries
Bas van Bakel · 2007
Almost all programmers and a lot of end users are familiar with the term SQL or even with writing SQL queries. The challenge comes with the querying and joining of numerous large tables; together with the performance, which drops rapidly, the maintainability decreases and debugging can become very complicated. This paper will introduce ground rules for a method of programming your SQL queries in a way that they are easy to maintain and debug. It will also show that a query developed in the proposed way will improve the performance enormously compared to other queries.