Chapter 17. Getting the Most from Your Queries

In the last chapter, you learned how to overcome limitations of queries. This chapter explores ways to make queries faster and more efficient. You also explore SQL-specific queries. In particular, you learn the following:

  • how to optimize your queries

  • how compacting optimizes your database

  • how indexing speeds up queries

  • how to avoid aggregate functions

  • how to include only fields that are needed

  • why using smaller data types helps optimization

  • why using outer joins sparingly helps optimization

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.