O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Query Optimization

The Microsoft Jet database engine has a built-in query optimizer that uses statistics to determine which query strategy to use. For this reason, you should open, resave, and run your queries to recompile them if you add a significant number of records to your database—especially if the records are added to the table on which a query is based. You also should recompile them in the event of an index change.

Unfortunately, you can neither view Jet database engine optimization schemes nor specify how you want to optimize a query. However, you can use the Database Documenter to find out whether indexes are present and how unique an index is. Simply choose Tools, Analyze, Performance from the Access toolbar. Because the query performance ...

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