IDUG Tech Talk: The ABCs of Filter Factors (aka Selectivity)

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).

The presentation was delivered at IDUG EMEA in Brussels this month.  Enjoy!

Watch “The ABCs of Filter Factors (aka Selectivity)” on ON24 video link and YouTube YouTube video link

 

Recent Stories
Advanced JSON Understanding how to Exploit Db2 Capabilities in the NoSQL World by George Baklarz

IBM Db2 Editions Simplified for Straightforward Deployment Options

Db2 Architecture Overview and BLU