Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book