[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 |