Database query optimization

Query Optimization
December 21, 2021 – 11:25 am
Database Systems: Design, Implementation, and Management Tenth

Query optimization is addressed shortly in Database Systems, this lecture looks at a broader topic of optimization techniques. It concentrates on the central issues like join ordering and access path selections, but gives an overview of the whole query processing machinery. The main goals of the lecture are twofold: First, to learn different optimization techniques, which are also relevant in other areas. And second, to get an understanding how queries are processed and why queries are fast or slow.




You can work on exercises in teams of two students. Specify names of both participants when submitting


  • J.D. Ullman. Database and Knowledge Base Systems. Computer Science Press, 1989.
  • T. Özsu and J. Blakeley. Modern Database Systems. Addison Wesley, 1995.
  • H. Garcia-Molina and J.D. Ullman and J. Widom. Database System Implementation. Prentice Hall, 1999.
  • P. Gassner, G. Lohman, and K. Schiefer. Query optimization in the IBM DB2 family. IEEE Data Engineering Bulletin, 16:4 18, Dec. 1993.
  • S. Chaudhuri. An Overview of Query Optimization in Relational Systems. PODS, 1998
  • G. Moerkotte. Building Query Compilers. (draft)
first coast no more homeless pets max secret life of pets pets megastore pets on trains craigslist huntsville, al pets we love pets abq craigslist pets bionic pets happy pets pets love shop for pets pets friendly hotel pets boarding near me operation pets present pets toys all pets hospital rc pets barely used pets best carpet shampooer for pets craigslist humboldt pets craigslist pets md pets shots pets supply fashionable pets pets cast crayola scribble scrubbie pets american service pets pets and people sofa covers for pets best reptile pets pets clinic ksl pets aqua pets best pets to have pets and such easy pets for kids craigslist terre haute pets adopt me ocean egg pets cages for pets all pets considered couch covers for pets connecticut craigslist pets castle crashers pets do pets go to heaven good pets for kids pets without parents inventory pets secret life of pets 2 characters hermit crabs as pets craigslist spokane pets are bearded dragons good pets do hedgehogs make good pets craigslist erie pa pets phoenix craigslist pets pets referral center craigslist monterey pets rainbow bridge pets wow classic best hunter pets best battle pets wow secret life of pets ride heartland pets spokane craigslist pets can wolves be pets
Related Posts