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