Abstract

This chapter describes the new Automated Statistics Collection (ASC) component of IBM® DB2® Universal DatabaseTM (DB2 UDB). This autonomic technology frees the DBA from the tedious task of manually supervising the collection and maintenance of database statistics. The use of inaccurate or outdated database statistics by the query optimizer in a relational Database Management System (DBMS) often results in a poor choice of query execution plans and hence unacceptably long query processing times. Configuration and maintenance of these statistics has traditionally been a time-consuming manual operation, requiring that the database administrator (DBA) continually monitors the query performance and data changes in order to determine when to refresh the statistics values, and when and how to adjust the set of statistics that the DBMS maintains. ASC monitors both the update-delete-insert (UDI) activities on the data as well as query feedback (QF). It uses these two sources of information to automatically decide which statistics to collect and when to collect them. This combination of UDI-driven and QF-driven autonomic processes ensures that the system can handle unforeseen queries while also ensuring good performance for frequent and important queries. Thus, the chapter presents the basic concepts, architecture, and key implementation details of ASC in DB2 UDB. It also presents a case study showing how the use of ASC can speed up a query workload by orders of magnitude without requiring any DBA intervention.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.