by Dan Tow
Published by O'Reilly Review by Deborah Whitehead I have used SQL to query the Oracle database in my application development. As my query getting more complicated, I noticed that my application significantly slow down. How to improve the query and get better response time is what I’m looking for. In this SQL Tuning book, the author presents a method for finding the optimum execution plan that could improve the query time. His way of tuning SQL statement using diagram is worthy to learn. If you are a person just want to learn the method to use for speeding up your SQL queries, go directly on chapter 5, 6, 7. In chapter 5 you will learn how to create the diagram and how to calculate the filter and join ratios. This chapter provides you the basic concept you need to know to diagram simple SQL queries. Then in chapter 6, you will learn how to use the diagram and how to find the best join tables’ order from the diagram. The author uses examples to explain the diagram in-depth. In chapter 7, the author presents how to use the diagram to tune on using sub queries, views, or union queries. I have to say it needs patient to read the book and learn the concept. It also requires strong mathematical understanding. While the theory is the good guideline for writing SQL statement that will run fast, it is worthy to keep it.
|
