SQL Tuning
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
O'Reilly & Associates, Inc., contact information for one-to-many joins, unintended one-to-one joins 2nd online queries, large optimization levels in DB2 OPTIMIZE FOR ROWS clause optimizers [See cost-based optimizer; rule-based optimizer] Optimizing Oracle Performance (Millsap) OPTION(FAST 1) hint OPTION(FORCE ORDER) hint OPTION(LOOP JOIN) hint OR operator, indexes disabled when using Oracle books about 2nd cost-based optimizer 2nd 3rd decoupling index reads from table reads execution plans complex displaying 2nd interpreting multipart nonrobust robust table for plan data extents function-based indexes hints used to control queries index-organized tables MINUS for EXCEPT operation notation for filter conditions in joins null conditions in indexed columns NVL() function used to disable indexes optimizers, choosing between partitioned tables rule-based optimizer 2nd TRUNCATE command type conversions with 2nd ORDER BY clause [See ordering] ORDERED hint ordering, not included in query diagram Ouroboros pattern [See purge eldest pattern] outer joins 2nd 3rd abnormal to detail table filtered to filtered detail table improving performance of, in DB2 join orders disabled when using leading to inner joins necessity of ratios for notation for optimizing join order for to views when to use
|