View Review Details

Book:   SQL Tuning
Subject:   Absolute needed book for a SQL tuning specialist - Highly recommended
Date:   2005-04-29 04:21:35
From:   Ertugrul Bayindir
Rating:  StarStarStarStarStar

As a senior data warehousing specialist, I used several tools and books for tuning SQL so far and none of is giving the methodology needed. Most of them giving information about facilities of the databases but not real life examples of how to use them. Now after reading this book I can tune SQL statements longer than 5 pages in length in just 2-3 hours. I did tuning for SQL statements having more than 20 tables in 2 hours. I am getting 4 to more than 10 times better run time performance regularly. I think this book turns black art of tuning to an engineering method.


I know it will be seem to like I am working for Oreilly but definetely not. I should also recommend another Oreilly book "Optimizing Oracle Performance" together with this book.
If you read both books I am sure you can do a great job.


For anyone interested, I created a small perl script which generates the tree like structures needed to tune SQL statements. It works on top of Business Objects repository(QM) to get the metadata needed. Therefore it is a BO only solution.

See larger cover