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

Part V: Overcoming Access Development Ob... > Getting the Most from Your Queries

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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