[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
queries
[See also joins]aggregating too many rows
2nd
3rd
altering to enable optimum execution plan
for batch reports, large
blind
choosing indexed access or full table scan for
complex queries
abnormal outer joins in
cyclic joins in
disconnected
joins with no primary keys in
multiple roots in
one-to-one joins in
set operations in
subqueries in
views in
distributed filters in
errors in
[See problem cases]middleware processes handling too many rows in
modifying with DB2
modifying with Oracle
modifying with SQL Server
multitable queries
online, large
performance effects of, estimating
read locks in, disabling
repeated a large number of times
2nd
returning too many rows
2nd
running slowly even when returning few rows
2nd
set operations in
simple
creating query diagrams for
criteria for
full query diagrams for
interpreting query diagrams for
simplified query diagrams for
single-table queries
subqueries in
converting existence checks to
correlated, forcing evaluation of
DB2 execution plan for
exercise for
2nd
EXISTS subqueries
2nd
3rd
4th
forcing execution order when using
NOT EXISTS subqueries
2nd
3rd
Oracle execution plan for
query diagrams for
SQL Server execution plan for
tuning
view-defining
2nd
view-using
2nd
3rd
4th
views in
Query Analyzer
[See SQL Server Query Analyzer]query diagrams
2nd
abstractness of
compared to entity-relationship diagrams
correlation joins in
creating
2nd
cyclic joins in
2nd
disconnected
example usage of
exercises for
2nd
filter conditions not included in
filter ratios in
2nd
3rd
4th
5th
full
2nd
grouping not included in
interpreting
join conditions not included in
join ratios in
2nd
3rd
4th
5th
6th
joins in
2nd
links in
multiple roots in
nodes in
nonunderlined numbers in
normal form reflected in
one-to-one joins in
ordering not included in
outer joins in
post-group filtering not included in
reasons for using
select lists not included in
simplified
2nd
3rd
subqueries in
table aliases in
table names not included in
underlined numbers in
view-using queries in
when to use
query skeleton
2nd
questions about this book, sending
|
لطفا منتظر باشید ...
• 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.
