Index E


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

entity-relationship diagrams  
equality condition, index ranges with  
errors   [See problem cases]
EXCEPT operation   [See set operations]
execution plans   2nd  
       controlling
               cost-based optimizer used for  
               disabling undesired index  
               disabling undesired join orders  
               enabling desired index  
               enabling desired join order  
               forcing execution order with subqueries  
               techniques for  
               with DB2  
               with Oracle cost-based optimizer   2nd  
               with Oracle rule-based optimizer  
               with SQL Server  
       DB2
               complex  
               displaying   2nd   3rd  
               interpreting  
               multipart  
               nonrubust  
               robust  
               tables for execution-plan data  
       exercise for   2nd  
       join order for
               calculating cost of  
               choosing   2nd   3rd  
               controlling   2nd  
               for outer joins  
       optimum
               assumptions for  
               finding   2nd   3rd   4th  
               for Cartesian products   2nd  
               for detail join ratios close to 1.0  
               for detail join ratios less than 1.0  
               for filter ratios close to each other  
               for join ratios less than 1.0  
               for large detail join ratios   2nd  
               for large root table  
               for large rowcount returned by query  
               for master join ratios less than 1.0   2nd  
               for master join ratios of 1.0  
               for one large table  
               for one small filter ratio  
               for small rowcounts returned  
               robust execution plans as  
               special cases for  
       Oracle
               complex  
               displaying   2nd  
               interpreting  
               multipart  
               nonrobust  
               robust  
               table for plan data  
       parallel   2nd  
       robust   2nd  
               creating missing indexes for  
               improving upon  
               reasons to choose  
       SQL Server
               complex  
               displaying   2nd  
               interpreting  
               nonrubust  
       tools for generating   2nd  
exercises
       creating query diagrams   2nd  
       diagramming and tuning query with subqueries   2nd  
       finding optimum execution plan   2nd  
EXISTS-type subquery   2nd  
       execution order when using  
       replacing INTERSECT  
EXPLAIN PLAN FOR statement   2nd  
EXPLAIN_ tables  
expressions, indexes disabled when using  
extents  



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