لطفا منتظر باشید ...
• 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.
1.5 Outside-the-Box Solutions
Finally, this
book discusses outside-the-box solutions: what to do about cases in
which you cannot make an individual query fast enough, when treating
the query as a spec for what the application requires at that point,
just tuning that single query, does not solve the problem. This
brings up a class of problems where you really do need to pay some
attention to what the application does, when you cannot just treat it
as an abstract black box that needs a specified set of rows from some
specified tables. Even so, there are some reliable rules of thumb for
the kinds of application-level changes that are likely to solve these
types of problems. You will likely need to work with developers who
know the application details (assuming you do not) to solve these
problems, but by understanding the rules you can still offer valuable
suggestions without application-specific knowledge.
