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

Chapter 9. Designing Queries for Jet Dat... > In the Real World—Optimizing Query D...

In the Real World—Optimizing Query Design

The objective of select query design is to convert raw data to useful information. The design of decision-support queries in production database applications is a combination of art and science.

The Art of Query Design

An artful query design returns the result set in the format that’s most meaningful to the recipient. For example, a query that displays orders sorted by customer and uses the customer code for identification might be understandable by a salesperson, but not management. Salespeople are likely to know the codes for their particular customers. Few sales or marketing managers, however, are capable of memorizing hundreds or thousands of codes. This is especially true if the codes are numeric, rather than based on the first few letters of customers’ names, as is the case for the Northwind Customers table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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