[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
aggregation
[See also grouping; post-group filtering]2nd
not included in query diagrams
queries aggregating too many rows
2nd
3rd
in reports
2nd
ALL_ROWS hint
AND-EQUAL MERGE operation
angle brackets (<>), surrounding missing portions of SQL statement
anti-join
2nd
apples-and-oranges tables
application
[See also queries]altering, determining necessity of
2nd
3rd
4th
5th
altering, example of
2nd
caching in
2nd
data volume produced by
2nd
3rd
transferring data between applications
arithmetic expressions, indexes disabled when using
arrowabsence of, at ends of link
at end of link
at midpoint of link
2nd
audience for this book
author, contact information for
|
لطفا منتظر باشید ...
• 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.
