|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
cache-hit ratio
2nd
caching
in application
2nd
B-tree indexes and
block buffer cache
continuous growth pattern and
full table scans and
indexed table access and
LRU caching
2nd
performance effects of
purge eldest pattern and
purge, not by age pattern and
self-caching
2nd
calcuations
[See benefit-to-cost ratio; cache-hit ratio; correlation preference ratio; join ratio; filter ratio] capitalized text used in this book
Cartesian join
2nd
Cartesian product
optimizing execution plan for
2nd
resulting from absence of join
resulting from query with multiple roots
2nd
3rd
CBO
[See cost-based optimizer] Central Processing Unit
[See CPU] cloud of nodes
COALESCE() function
cold blocks
2nd
columns relevance to SQL tuning
statistics for, used by cost-based optimizer
comments about this book, sending
complete purge and regrowth pattern
complex queries
2nd
abnormal outer joins in
cyclic joins in
disconnected queries
joins with no primary key in
multiple roots in
one-to-one joins in
set operations in
subqueries in
views in
conditions
[See filters; joins; selectivity] contact information for this book
continuous growth pattern
conventions used in this book
corner-case problems
abnormal query diagrams indicating
changing functionality for
view-using queries causing
correlated subqueries, forcing evaluation of
correlation joins
2nd
anti-join
2nd
in query diagrams
semi-join
2nd
correlation preference ratio
2nd
3rd
cost-based optimizer
2nd
choosing
controlling execution plans with
response to varying table and index sizes
rule-based optimizer used with
statistics affecting
2nd
CPU (Central Processing Unit)
cyclic join graph
2nd
|