Model a Database Index

A database index on a database Table is used to improve the performance of lookups and sort operations on the Table at the expense of additional storage.

Access     Tools | Database Builder | Click on Table name > Constraints | Right-click | Add New Constraint (Ctrl+N)


A new constraint is added to the Constraints tab, with the default type index. See the Help topic Database Indexes for information on defining the new index.

To delete a database index you no longer require, right-click on the index name on the Constraints tab and select the Delete constraint <name> option. The index is immediately removed.

Learn more