SQL Processing
Tapio Lahdenmäki, Michael Leach · 2005
How indexes and tables are used to process SQL statements; SQL processing concepts; predicates. Optimizers and access paths; index slices, matching index scans and matching columns, index screening and screening columns; when the access path is chosen; monitoring the optimizer; helping the optimizer with statistics and the number of FETCH calls required. The very important concepts of filter factor, selectivity and cardinality, together with their impact on index design. The materialization of the result table and its implications.