UNDERSTANDING OPTIMIZATION TECHNIQUES
The following sections cover some simple techniques to optimize performance in Access. Included are tricks dealing with relationships, indexes, whole database structures, and performance tuning.
Increasing Performance with Table Relationships
To be certain that Access has the greatest possible choice when determining indexes to use, you should create relationships between tables that will be joined. When you set up relationships in Access, not only are you defining referential integrity and cascading operations, but you're also creating indexes on the tables.
Some indexes are exposed when the indexes collection for a table is viewed. The Foreign property indicates an index that was created because of a relationship ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
