Cross Platform DB2 for z/OS & LUW

E12 - The ABCs of Filter Factors (aka Selectivity) 

Sep 18, 2016 10:56 PM

Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them (with more statistics, or by telling DB2 what the filter factor is).

Attachment(s)
pdf file
The ABCs of Filter Factors (aka Selectivity) EU2016 E12 ...pdf   1.32 MB   1 version
Uploaded - Jun 05, 2020
pdf file
The ABCs of Filter Factors (aka Selectivity) EU2016 E12.pdf   8.72 MB   1 version
Uploaded - Jun 05, 2020
pdf file
The ABCs of Filter Factors (aka Selectivity) EU2016 E12.pdf   8.72 MB   1 version
Uploaded - Jun 05, 2020
pptx file
The ABCs of Filter Factors (aka Selectivity) EU2016 E12.pptx   1.18 MB   1 version
Uploaded - Jun 05, 2020
pptx file
The ABCs of Filter Factors (aka Selectivity) EU2016 E12.pptx   1.18 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.