Automated Statistics Collection in DB2 UDB

Proceedings 2004 VLDB Conference: The 30th International Conference on Very Large Databases (VLDB)

Volumn , Issue , 2004, Pages 1146-1157

  Aboulnaga, A ^a   Haas, P ^a   Lohman, G ^a   Markl, V ^a   Raman, V ^a   Kandil, M ^b   Lightstone, S ^b   Popivanov, I ^b  

^a IBM ALMADEN RESEARCH CENTER   (United States)

^b IBM TORONTO LAB   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85035575988     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-012088469-8.50100-5     Document Type: Chapter

References (17)

1. A. Aboulnaga and S. Chaudhuri (June, 1999) Self-tuning histograms: Building histograms without looking at data. Proc. 1999 ACM SIGMOD 181-192.
2. M. Ault, M. Tumma, D. Liu and D. Burleson (2003) Oracle Database 10g New Features: Oracle 10g Reference for Advanced Tuning and Administration Rampant TechPress
3. N. Bruno, S. Chaudhuri and L. Gravano (June 2001) STHoles: a multidimensional workload-aware histogram. Proc. 2001 ACM SIGMOD 211-222.
4. N. Bruno and S. Chaudhuri (June, 2002) Exploiting statistics on query expressions for optimization. Proc. 2002 ACM SIGMOD 263-274.
5. S. Chaudhuri and V. Narasayya (2001) Automating statistics management for query optimizers. IEEE Trans. Knowl. Data Engrg. 13(1), 7-20.
6. DB2 Universal Database for iSeries-Database Performance and Query Optimization IBM Corp.
7. DB2 v8.2 Performance Guide IBM Corp.
8. I.F. Ilyas, V. Markl, P.J. Haas, P.G. Brown and A. Aboulnaga (June 2004) CORDS: Automatic discovery of correlations and soft functional dependencies. Proc. 2004 ACM SIGMOD To appear
9. S. Lightstone, G. Lohman and D. Zilio (2002) Toward autonomic computing with DB2 Universal Database. SIGMOD Record 31(3)
10. S. Lightstone, B. Schiefer and D. Zilio (2003) Autonomic computing for relational databases: the ten year vision. Proc. IEEE Workshop Autonomic Computing Principles and Architectures (AUCOPA '03)
11. L. Lim, M. Wang and J.S. Vitter (2003) SASH: A self-adaptive histogram set for dynamically changing workloads. Proc. 29th VLDB 369-380.
12. SQL Server 2000 Books Online v8.00.02 Microsoft Corp.
13. V. Poosala, Y. Ioannidis, P. Haas and E. Shekita (June 1996) Improved histograms for selectivity estimation of range predicates. Proc. 1996 ACM SIGMOD 294-305.
14. S. Parekh, K. Rose, J. Hellerstein, S. Lightstone, M. Huras and V. Chang (2003) Managing the Performance Impact of Administrative Utilities. IBM Research Report RC22864 IBM Corp.
15. S. Parekh, K. Rose, J. Hellerstein, V. Chang, S. Lightstone and M. Huras (October, 2003) A general approach to policy-based management of the performance impact of administrative utilities. Proc. 14th IFIP/IEEE Intl. Workshop Distributed Systems: Operations and Management (DSOM '03) 20-22.
16. M. Stillger, G.M. Lohman, V. Markl and M. Kandil (2001) LEO-DB2's LEarning Optimizer. Proc. 27th VLDB 19-28.
17. Q. Zhu, B. Dunkel, N. Soparkar, S. Chen, B. Schiefer and T. Lai (1998) A piggyback method to collect statistics for query optimization in database management systems. Proc. 1998 Conf. Centre for Advanced Studies on Collaborative Research (CASCON '98)