SQL Performance Tuning

SQL Performance Tuning by Mary O'Brien. paperback edition. ISBN: 9780201791693.

A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBAs and programmers improve the performance of their databases. It is not an introduction to SQL, nor is it a tuning manual for a particular SQL implementation. It is a guide for users and programmers who want to improve SQL performance no matter what brand of SQL they use. It will provide tuning tips for common situations, such as how to change a query so it will go faster and how to shift work from the server to the client. All the ideas have been tested against the eight leading DBMS applications. Almost all large organizations and companies today run more than one type of database. This is the only book to cover database tuning for them.