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

Part: II MANIPULATING AND PRESENTING DAT... > USING QUERIES TO GET THE MOST OUT OF...

Chapter 8. USING QUERIES TO GET THE MOST OUT OF YOUR DATA

IN THIS CHAPTER

Queries can make you a hero or get you killed. To come out the hero, you need to consider how you use them. For example, you have some code that runs through various recordsets and examines pieces of data that will be used later. Because this process is being performed on a million-record table, it takes 20 minutes to run. But if you come up with an Access query that takes only five minutes to run because of Jet's optimizations, you're then crowned king.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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