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.