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

Chapter 11. Creating Multitable and Cros... > In the Real World—Optimizing Multita...

In the Real World—Optimizing Multitable Queries

Chapter 9's “In the Real World—Query Design Optimization” section discusses the art and science of query design to optimize the presentation of information and query performance. The single-table query design recommendations apply equally to multitable queries.

This chapter is one of the longest in the book because of the importance of multitable SELECT and SQL aggregate queries in production database applications. Joins are fundamental to relational databases. You're likely to find that more than 75% of the queries you create require at least one join, and a substantial percentage need two or more joins.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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