12.14: To Index or Not to Index?

Computer Applications for Managers · LibreTexts

0%

Contents

    Text

    Size
    100%
    Theme
    Typeface
    Line length
    Spacing

    From LibreTexts, under CC BY 4.0, as the source states it; its equations are written in TeX, which the PDF shows typeset. This page at LibreTexts.

    Learning Outcomes

    • Determine when to use an index

    Despite the stated advantages of indexing, there are some drawbacks as well. Indexes add metadata to the database, which increases its size and disk space requirements. In addition, when a new record is added to an indexed table, there is a slight performance hit—for 20 indexes on a table, Access will make 20 adjustments when a new record is added or subtracted. So, you will want to avoid indexing on smaller tables or tables that are not frequently involved in queries.

    Practice Question

    https://assessments.lumenlearning.co...essments/18760

    Contributors and Attributions

    CC licensed content, Original
    • To Index or Not to Index?. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    This page titled 12.14: To Index or Not to Index? was last modified on Sun, 07 Mar 2021 18:26:17 GMT and is shared under a CC BY 4.0 license and was authored, remixed, and/or curated by Lumen Learning via source content that was edited to the style and standards of the LibreTexts platform.