Skip to main content
Business LibreTexts

12.14: To Index or Not to Index?

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    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.

    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

    12.14: To Index or Not to Index? is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?