Revealing the Secrets to Coding SQL
"SQL Performance Tuning" will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval."SQL Performance Tuning" is a book that will take the database developer to the next level. This book will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval. Peter Gulutzan and Trudy Pelzer do a wonderful job explaining the methods behind the madness of the most common SQL commands. They take the top eight SQL database products and compare each of them in terms of how they use standard commands. At the same time, the authors show you how to optimize your code and demonstrate the performance gains that you will see when the updated code is executed. The top eight SQL database products covered in this publication are: IBMs DB2, IBMs Informix, Computer Associates Ingres, Borlands Interbase, Microsoft SQL Server, the open source MySQL, Oracle and Sybase. For each standard command on each platform, the authors not only show you how to tune your code to make it run more efficiently, they also explain in great detail why the new code works better. This is a wonderful addition as it helps the programmer to get behind the tools and better understand what is going on within them. With that understanding, the programmer will have the skills needed to fine-tune code for maximum efficiency in the future.
This book covers all the major commands within the SQL standard and also warns you of any anomalies within the specific tools to watch out for. The SELECT command, for example, is covered in great detail. And all the optional portions of the command like GROUP BY and ORDER BY are covered to show just how the SQL products are retrieving the information.