Index T

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

tables  
       adding, for joins with hidden join filters  
       aliases of, in query diagrams  
       apples-and-oranges tables  
       combining
               for exact one-to-one joins  
               for tables with hidden join filters  
       complete purge and regrowth pattern for  
       conditions on   [See filters; joins; selectivity]
       continuous growth pattern for  
       detail table  
       driving   2nd   3rd   4th   5th   6th  
       focus table  
       full table scan   2nd   3rd   4th   5th  
       growth patterns for  
       high-water mark of   2nd   3rd  
       index-organized  
       indexed access of   2nd   3rd   4th  
       large
                affecting caching   2nd  
               affecting indexed read performance   2nd  
               affecting optimum execution plan   2nd  
               nested loops for  
       master table  
       multitable clusters  
       multitable queries  
        names of, not included in query diagram  
       nodes representing   [See nodes]
       partitioned  
       physical layout of, affecting performance  
       purge eldest pattern for  
       purge, not by age pattern for  
       root detail table  
       selectivity on rows reached from index  
       separating, for one-to-one join to small subset  
       single-table access paths  
       single-table clusters  
       single-table queries  
       size of
               cost-based optimizer's response to  
               indicating necessity of index  
               represented in query diagrams  
       small, affecting caching  
       statistics for, used by cost-based optimizer  
throughput   2nd   [See also performance]
TOAD software tool  
transitivity, implying missing join conditions with  
TRUNCATE command  
tuning   [See SQL tuning]
tuple  
two-node filter   2nd  
type conversions, indexes enabled and disabled by   2nd