لطفا منتظر باشید ...
• 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 9. Special Cases
Defer no time; delays have dangerous ends.William Shakespeare King Henry the Sixth, Part I
This chapter covers a collection of special cases that occasionally
arise. Chapter 6 and Chapter 7 cover standard solutions to standard classes
of the problem "What execution plan do I
want?" Here, I extend those solutions to handle
several special cases better.
