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