لطفا منتظر باشید ...
• Table of Contents• Index• Reviews• Examples• Reader Reviews• Errata• AcademicSQL TuningBy
Publisher: OReillyPub Date: November 2003ISBN: 0-596-00573-3Pages: 336
SQL Tuning author Dan Tow outlines a
timesaving method hes developed for finding the optimum
execution plan--rapidly and systematically--regardless of
the complexity of the SQL or the database platform being
used. Youll learn how to understand and control SQL
execution plans and how to diagram SQL queries to deduce the
best execution plan for a query. Key chapters in the book
includes exercises to reinforce the concepts youve learned.
SQL Tuning concludes by addressing
special concerns and unique solutions to "unsolvable"
problems.
Chapter 8. Why the Diagramming Method Works
It is well to moor your bark with two anchors.Publilius Syrus (a.k.a. Publius) Maxim 119
Chapter 5-Chapter 7
covered how to tune SQL with the diagramming method but did not
discuss why the method leads to well-tuned SQL. With a lot of faith
and good memory, you could likely get by without knowing why the
method works. However, even with unbounded, blind faith in the
method, you will likely have to explain your SQL changes
occasionally. Furthermore, the method is complex enough that an
understanding of why it works will help you remember its details
better than blind memorization ever could.
