• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. USING QUERIES TO GET THE MOST... > EXAMINING THE ARCHITECTURE OF THE QU...

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 and how to relate them. It's very important to review your thinking on this and make sure that you're asking the right question.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint