لطفا منتظر باشید ...
• 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 5. Diagramming Simple SQL Queries
Look ere ye leap.John Heywood Proverbs [1546], Pt. I, Ch. 2
To convert the art of SQL tuning to a science requires a common
language, a common paradigm for describing and
solving SQL tuning problems. This book teaches, for the first time in
print in any detail, a method that has served me well and served
others I have taught over many years. I call this method the
query diagramming method.Like any new tool, the query diagramming method requires some
up-front investment from the would-be tool user. However, mastery of
this tool offers tremendous rewards, so I urge you to be patient; the
method seems hard only for a while. Soon, it will lead you to answers
you would never have found without the tool, with moderate effort,
and in the end it can become so second-nature that (like the best
tools) you forget you are using it.
