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.