|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
filter conditions
2nd
[See also filters] filter independence
2nd
filter ratio
2nd
calculating
choosing driving table using
2nd
close to each other, affecting optimum execution plan
example of
notation in query diagrams
of later tables, considering in join order
one small filter ratio, affecting optimum execution plan
precision of
2nd
query-specific information provided by
rowcount and
subquery adjusted filter ratio
2nd
filter redundancy
2nd
filtered outer joins
filters absence of, in queries
distributed
2nd
index merging filter column and join key
join filters
2nd
3rd
4th
not included in query diagrams
notation for
notation for best and lesser filters
percentage of table satisfying
[See filter ratio] places applied in database
post-read filter
2nd
3rd
selectivity of
two-node filter
2nd
uniqueness of, guaranteeing
work required by database for
FIRST_ROWS hint
focus table
fonts used in this book
FORCEPLAN option
foreign key
2nd
full index scan
2nd
full query diagrams
2nd
full table scan
2nd
forcing use of
2nd
when to use
FULL() hint
function-based indexes
functions, indexes disabled when using
|