[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
range-condition selectivity for index
[See index range-condition selectivity]ratios
[See benefit-to-cost ratio; cache-hit ratio; correlation preference ratio; filter ratio; join ratio]RBO
[See rule-based optimizer]read locks, disabling in queries
redundant joins, enabling join order
referential integrity
2nd
relative running rowcount
repeated queries
2nd
reports, batch
robust execution plans
2nd
creating missing indexes for
improving upon
reasons to choose
root block
2nd
root detail table
root nodes, multiple, in query diagram
rowcount
correlated subqueries affecting
estimating cost of joins using
filter ratios and
inner joins affecting
large, join execution method for
relative running rowcount
running rowcount
smalljoin execution method for
running slowly
rowid
2nd
rows, reading first rows quickly
2nd
rowset
RULE hint
rule-based optimizer
2nd
choosing
cost-based optimizer used with
disabling unintentionally
running rowcount
|
لطفا منتظر باشید ...
• 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.
