Index I


[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  



SQL Tuning
SQL Tuning
ISBN: 0596005733
EAN: 2147483647
Year: 2003
Pages: 110
Authors: Dan Tow

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net