SQL Tuning [Electronic resources] نسخه متنی

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