Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
Ananya

New User

Joined: 26 Feb 2004
Posts: 19
Location: Chennai

 Posted: Fri Feb 27, 2004 4:04 pm    Post subject: FILTER FACTOR Dear All, 1. What is a FILTER Factor? 2. What is the Functionality of this Filter Factor? Pls. Help me. Cheers -Ananya

Active User

Joined: 06 Jan 2004
Posts: 247

 Posted: Fri Feb 27, 2004 5:42 pm    Post subject: FILTER FACTORS hi ananya, Filter factors affect the choice of access paths by estimating the number of rows qualified by a set of predicates. These estimates the proportion of rows in a table for which the predicate is true. Those rows are said to qualify by that predicate. suppose for table EMP consider in the NAME COLUMN there are 4 distinct names say A B C and D.so now 1/4 th of the rows have value A in NAME column.Then the predicate NAME='A' has the filter factor 0.25 for table EMP. Statistics generated by runstats helps in calculating FILTER FACTOR. hope this give u some idea atleast. THANKS AND REGARDS ANU
Ananya

New User

Joined: 26 Feb 2004
Posts: 19
Location: Chennai

 Posted: Sat Feb 28, 2004 1:06 pm    Post subject: Dear Anu, Thanks for the Help. Your comprehension is beyond my understanding. But one thing I understood is, a Filter Factor is 1 / No.Of. Distinct rows of a Column. Can you please put this a little more simpler of why a Filter Factor is applied? Cheers -Ananya

Active User

Joined: 06 Jan 2004
Posts: 247

 Posted: Mon Mar 01, 2004 10:14 pm    Post subject: filter factor hi ananya, As i said earlier filter factor affect the choice of access paths.The optimizer uses filter factor(not only this.still many factors) to choose the best method for accessing data. There will be two phases in processing a query. compile phase(also known as PREPARE or BIND phase), and the EXECUTE phase. In the COMPILE phase, the DBMS chooses an optimal Access Path (or access strategy) to compute the result of the query. Once chosen, the access path is stored in an object known as an Access Plan that can be retrieved for later use. The Access Plan is then executed in the EXECUTE phase to produce the result for returning to the application. Typically, a query is associated with a single access plan. Access Plan can be shared and reuse for multiple execute requests by multiple applications executing the same query. DBMSs collect and maintain a multitude of statistical information about the data they manage in order to optimize access paths for queries on these data. Such statistics include the distribution of the data and frequent occurring values in the data. One important usage of these statistics is in the computing Filter Factor (how many rows in the table or relation will qualify a given predicate) of various predicates in queries. The Filter Factor of predicates is basis for DBMSs to select optimal access paths for queries. hope this time u should get a clear idea. right!!!!!!!!!. OK HAVE A NICE DAY ANANYA. Thanks and regards ANU
mdtendulkar

Active User

Joined: 29 Jul 2003
Posts: 238
Location: USA

Posted: Wed Mar 03, 2004 1:26 pm    Post subject:

Hello Ananya,

 Code: http://vsis-www.informatik.uni-hamburg.de/teaching/ws-03.04/edbec/db2library/db2t0e80.pdf https://aurora.vcu.edu/db2help/db2t0/db2t0.htm http://www.frc.utn.edu.ar/campus/ibm/pdfs/sg242213.pdf http://www.dbis.informatik.uni-frankfurt.de/~schommer/wise02/practical/exerc/DB2Glossary.pdf

Hope this helps,

Regards
Mayuresh Tendulkar
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics filter COMMIT/ROLLBACK statements jzhardy DFSORT/ICETOOL 13 Fri May 01, 2020 5:27 pm Please help - SORT with SUM fields an... clearskynot DFSORT/ICETOOL 6 Thu Apr 09, 2020 11:01 am SMS:- Efficient filter lists in ACS Ravi GA All Other Mainframe Topics 6 Tue Mar 31, 2020 11:02 pm Filter group of records based on key mistah kurtz DFSORT/ICETOOL 11 Fri Jun 19, 2015 6:09 pm How to filter out the data by YYMM(ye... mkk157 DFSORT/ICETOOL 3 Tue Jul 15, 2014 4:26 pm

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us