Index R

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

range-condition selectivity for index   [See index range-condition selectivity]
ratios   [See benefit-to-cost ratio; cache-hit ratio; correlation preference ratio; filter ratio; join ratio]
RBO   [See rule-based optimizer]
read locks, disabling in queries  
redundant joins, enabling join order  
referential integrity   2nd  
relative running rowcount  
repeated queries   2nd  
reports , batch  
robust execution plans   2nd  
       creating missing indexes for  
       improving upon  
       reasons to choose  
root block   2nd  
root detail table  
root nodes, multiple, in query diagram  
rowcount  
       correlated subqueries affecting  
       estimating cost of joins using  
       filter ratios and  
       inner joins affecting  
       large, join execution method for  
       relative running rowcount  
       running rowcount  
       small
               join execution method for  
               running slowly  
rowid   2nd  
rows, reading first rows quickly   2nd  
rowset  
RULE hint  
rule-based optimizer   2nd  
       choosing  
       cost-based optimizer used with  
       disabling unintentionally  
running rowcount