@inproceedings{DBLP:conf/sigmod/Wang92, author = {Yun Wang}, editor = {Michael Stonebraker}, title = {Experience from a Real Life Query Optimizer}, booktitle = {Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data, San Diego, California, June 2-5, 1992}, publisher = {ACM Press}, year = {1992}, pages = {286}, ee = {http://doi.acm.org/10.1145/130283.130325, db/conf/sigmod/Wang92.html}, crossref = {DBLP:conf/sigmod/92}, bibsource = {DBLP, http://dblp.uni-trier.de} }BibTeX
DB2 is a major relational database system on IBM main frames, it has over six thousand licenses over the world to support a very large number of major applications for customer business.
Optimizer in DB2 is a critical component for the query processing, it inherited system R technologies and has been improved in very many aspects from numerous valuable real life experiences on customer applications. The major DB2 optimizer enhancements will be discussed with the backgrounds and examples. A wish list for future enhancements as well as some trend and direction of DB2 optimizer will also be discussed.
Copyright © 1992 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.
CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...