This post originated from an RSS feed registered with Java Buzz
by Dominic Da Silva.
Original Post: SQL Tuning: a book for every database developer
Feed Title: dsuspense
Feed URL: http://tss9.serverconfig.com/suspended.page/
Feed Description: Java/J2EE, .NET, OpenSource, Orlando living, Trinidad stuff and of course the Dolphins!...
Wow!...that is all I can say after getting this great book. SQL Tuning is a book that I highly recommend to all developers who use a database on a daily basis.
Especially those currently working with the O/R tools like Hibernate and JDO.
Some may think that they should leave all the hard work to the O/R mapping tool, and not pay much attention to composing your filters and WHERE clauses to produce the closest-to-optimum execution plan
400
for the underlying SQL statement.
But knowing and possibly debugging the generated SQL is handy when you need to tune your app for performance.
This book teaches you the art of:
1. Finding and interpreting an SQL statement's execution plan.
2. Changing the SQL to get a specific alternative execution plan.
3. Decide which execution plan a query should use.
It covers Oracle, SQL Server, and DB2, with good examples, and SQL statement execution fundamentals.
Definitely an eye opening book for me.