|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
O'Reilly & Associates, Inc., contact information for
one-to-many joins, unintended
one-to-one joins
2nd
online queries, large
optimization levels in DB2
OPTIMIZE FOR ROWS clause
optimizers
[See cost-based optimizer; rule-based optimizer] Optimizing Oracle Performance (Millsap)
OPTION(FAST 1) hint
OPTION(FORCE ORDER) hint
OPTION(LOOP JOIN) hint
OR operator, indexes disabled when using
Oracle books about
2nd
cost-based optimizer
2nd
3rd
decoupling index reads from table reads
execution plans complex
displaying
2nd
interpreting
multipart
nonrobust
robust
table for plan data
extents
function-based indexes
hints used to control queries
index-organized tables
MINUS for EXCEPT operation
notation for filter conditions in joins
null conditions in indexed columns
NVL() function used to disable indexes
optimizers, choosing between
partitioned tables
rule-based optimizer
2nd
TRUNCATE command
type conversions with
2nd
ORDER BY clause
[See ordering] ORDERED hint
ordering, not included in query diagram
Ouroboros pattern
[See purge eldest pattern] outer joins
2nd
3rd
abnormal
to detail table
filtered
to filtered detail table
improving performance of, in DB2
join orders disabled when using
leading to inner joins
necessity of ratios for
notation for
optimizing join order for
to views
when to use
|