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