DISCOVERING JET OPTIMIZATION METHODS

The following sections cover some of the optimization methods that the Jet database engine applies during the optimization porting of the query resolution process. This includes taking advantage of Rushmore technology, paying attention to when to use indexes, and understanding how Jet optimizes queries.

Using Rushmore Technology

Rushmore technology is a query technology that takes advantage of indexes. First introduced in FoxPro 2 by Fox Software, its creator got its name from the movie North by Northwest (how's that for trivia?). Access 2 inherited some of the Rushmore technology, and you can greatly increase performance by taking advantage of it.

Rushmore technology involves using the indexes on tables to ...

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.