Index O

[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