Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
FILTER FACTOR

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Ananya

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Fri Feb 27, 2004 4:04 pm    Post subject: FILTER FACTOR
Reply with quote

Dear All,

1. What is a FILTER Factor?

2. What is the Functionality of this Filter Factor?

Pls. Help me.

Cheers

-Ananya
Back to top
View user's profile Send private message

anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Fri Feb 27, 2004 5:42 pm    Post subject: FILTER FACTORS
Reply with quote

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
Back to top
View user's profile Send private message
Ananya

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Sat Feb 28, 2004 1:06 pm    Post subject:
Reply with quote

Dear Anu,

Thanks for the Help. Your comprehension is beyond my understanding. icon_cry.gif

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
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Mon Mar 01, 2004 10:14 pm    Post subject: filter factor
Reply with quote

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. icon_idea.gif right!!!!!!!!!.

OK HAVE A NICE DAY ANANYA.


Thanks and regards
ANU icon_lol.gif
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Wed Mar 03, 2004 1:26 pm    Post subject:
Reply with quote

Hello Ananya,

Check out the following links for more information
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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Filter group of records based on key mistah kurtz DFSORT/ICETOOL 11 Fri Jun 19, 2015 6:09 pm
No new posts How to filter out the data by YYMM(ye... mkk157 DFSORT/ICETOOL 3 Tue Jul 15, 2014 4:26 pm
No new posts SDSF filter swap? Ed Goodman IBM Tools 3 Mon May 05, 2014 7:13 pm
No new posts How to filter out data by date using ... expat JCL & VSAM 9 Wed Feb 20, 2013 12:13 pm
No new posts JCL SORT - FILTER RECORDS WITH CRITER... srinut123 DFSORT/ICETOOL 2 Mon Apr 30, 2012 4:28 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us