- Define indexes
- Set the properties of indexes
- Determine when to use an index
Indexes are another key concept in relational database technology. We will explore how indexes relate to the operation and performance of databases. Then, we will learn that indexes have properties too, and they can help handle some inconvenient situations. Finally, we will have a discussion of the advantages of indexing versus the disadvantages in certain cases.
You can view the transcript for “How to Add an Index to Your MS Access Table” here (opens in new window).