Index F

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

filter conditions   2nd   [See also filters]
filter independence   2nd  
filter ratio   2nd  
       calculating  
       choosing driving table using   2nd  
       close to each other, affecting optimum execution plan  
       example of  
       notation in query diagrams  
       of later tables, considering in join order  
       one small filter ratio, affecting optimum execution plan  
       precision of   2nd  
       query-specific information provided by  
       rowcount and  
       subquery adjusted filter ratio   2nd  
filter redundancy   2nd  
filtered outer joins  
filters
       absence of, in queries  
       distributed   2nd  
       index merging filter column and join key  
       join filters   2nd   3rd   4th  
       not included in query diagrams  
       notation for  
       notation for best and lesser filters  
       percentage of table satisfying   [See filter ratio]
       places applied in database  
       post-read filter   2nd   3rd  
       selectivity of  
        two-node filter   2nd  
       uniqueness of, guaranteeing  
       work required by database for  
FIRST_ROWS hint  
focus table  
fonts used in this book  
FORCEPLAN option  
foreign key   2nd  
full index scan   2nd  
full query diagrams   2nd  
full table scan   2nd  
       forcing use of   2nd  
       when to use  
FULL() hint  
function-based indexes  
functions, indexes disabled when using