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

EXAMINING THE ARCHITECTURE OF THE QUERY RESOLUTION PROCESS

Before you spend quality time tuning the performance of queries, it's important that you understand the process that resolves the request. From the first instant you decide to pose a question to the database in terms of a query, you begin to follow a series of steps that you hope will result in an accurate, timely result. When you begin to optimize the query, it helps to understand these steps and know which part of the process you're optimizing.

Defining the Query

Many developers don't include a definition as part of query resolution, but it does affect how the query is resolved. When deciding how to pose the query to the database, you've probably already determined which tables to use ...

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