|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
I/O (Input/Output)
logical
2nd
3rd
4th
physical
2nd
3rd
icons used in this book
IN condition, execution order when using
index blocks
2nd
3rd
4th
index range scan
2nd
index range-condition selectivity
INDEX() hint
index-organized tables
INDEX_DESC() hint
indexed table access
in DB2 execution plan
in Oracle execution plan
in SQL Server execution plan
when to use
indexes
2nd
3rd
adding for specific queries
adding, effects on performance
B-tree indexes
2nd
bit-mapped indexes
combining
date-type columns in
disabling use of
dropping, risks of
enabling use of
forcing use in descending order
forcing use of specific index
2nd
full index scan
2nd
function-based
with merged join key and filter columns
missing
2nd
3rd
rowids used by
satisfying query without accessing database
selectivity on rows reached from
size of caching and
2nd
cost-based optimizer's response to
statistics for, used by cost-based optimizer
updating, performance effects of
individual-condition filter selectivity
2nd
inequality condition, index ranges with
2nd
inner joins
2nd
3rd
Input/Output
[See I/O] inserts into index, performance effects of
INTERSECT operation
[See set operations] italic font used in this book
2nd
|