• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using Access Indexes

Access automatically creates an index on the primary key field. Adding other indexes to Access tables is a doubled-edged sword. You speed up the performance of queries because the index assists in the location of required records. Foreign key indexes speed access to related records; Access automatically adds an index on each foreign key when you establish relationships between tables. On the other hand, when you append a new record, Access must take the time to update each of the table's indexes. When you edit a field of a record that's included in one or more indexes, Access must update each of the indexes affected by the edit.

You can improve the performance of Access applications, especially with tables having large numbers of records or queries that join several tables, by observing these guidelines:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint