Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is filter factor?

asked mar August 25, 2014 12:13 PM  

What is filter factor?


1 Answers

answered By Mswami   0  
The filter factor is a ratio (a number between 0 and 1) that estimates I/O costs. It is an estimate of the proportion of table rows for which a predicate is true. The formulas used by the optimizer to calculate the filter factor are proprietary IBM information.

These formulas assume uniform data distribution, so they should be used only when determining the filter factor for static SQL queries or queries on tables having no distribution statistics stored in the DB2 Catalog. The filter factor for dynamic SQL queries is calculated using the distribution statistics, in SYSCOLDIST , if available.

Filter Factor is the percentage of rows that qualify for a coded predicate. It determines if an index will be used. 
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 1 year and 1 month ago ago
Number of Views -393
Number of Answers -1
Last updated
2 years and 2 months ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!