To Index or Not to Index?

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

Contribute!

Did you have an idea for improving this content? We’d love your input.

Improve this pageLearn More