[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
B-tree indexes
2nd
batch reports, large
Beaulieu, Alan (Mastering Oracle SQL)
benefit-to-cost ratio
2nd
bind variable peeking
bit-mapped indexes
blind queries
block buffer cache
2nd
blocks
2nd
branch
2nd
cold
2nd
hot
2nd
caching of
2nd
choosing for performance
hot data grouped in
indexed access and
physical I/O on
query causing
leaf
2nd
LRU (least recently used)
MRU (most recently used)
root
2nd
booksabout Oracle Performance
about Oracle SQL
branch blocks
2nd
|
لطفا منتظر باشید ...
• 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.
