O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required