O'Connell defines join selection factor as "[t]he percentage (or fraction) of records in one file that will be joined with records of another file".[1] This can be calculated when two database tables are to be joined. It is primarily concerned with query optimisation.
References
- ^ O'Connell, S. (2005) Advanced Databases Course Notes, Southampton, University of Southampton, section 5.10
This article is copied from an
article on Wikipedia® - the free encyclopedia created and edited by its online user community. The text was not checked or edited by anyone on our staff. Although the vast majority of Wikipedia® encyclopedia articles provide accurate and timely information, please do not assume the accuracy of any particular article. This article is distributed under the terms of
GNU Free Documentation License.
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.