Intelligent Statistics Management in Sybase ASE 15.0
Sybase ASE (Adaptive Server Enterprise) is a cost based database system. Statistics information plays a key role in the costing model of ASE optimizer. Typically, up-to-date statistics is critical in selecting an optimal query plan with good performance. However, updating statistics is a resource intensive maintenance operation. A common user concern is the lack of input on when statistics needs to be updated and also the time taken to maintain the statistics. In this paper, we introduce a new solution for automating statistics maintenance in Sybase ASE 15.0. Our solution includes a new metric for evaluating data changes due to DMLs (Data Management Language), the use of a scheduler to generate rules to gather statistics based on feedback from the metric and random sampling of data when gathering statistics. This approach will make statistics maintenance more intelligent and efficient, and reduce the TCO (Total Cost of Ownership) significantly.
KeywordsDatabase Administrator Statistic Maintenance Update Statistics Accurate Statistic Query Processor
Unable to display preview. Download preview PDF.
- 1.2005 Winter TopTen Award Winners, Winter Corporation (2005)Google Scholar
- 2.Ault, M., Tumma, M., Liu, D., Burleson, D.: Oracle Database 10g New Features: Oracle 10g Reference for Advanced Tuning and Administration. Rampant TechPress (2003)Google Scholar
- 3.Chaudhuri, S., Motwani, R., Narasayya, V.: Random Sampling for Histogram Construction: How much is enough? In: Proc. ACM SIGMOD Conference (1998)Google Scholar
- 4.DB2 Universal Database for iSeries – Database Performance and Query Optimization, IBM Corp. (2002)Google Scholar
- 5.Ling, Y., Sun, W.: An Evaluation of Sampling-Based Size Estimation Methods for Selections in Database Systems. In: Proc. IEEE Conference on Data Engineering (1995)Google Scholar
- 6.Lipton, R.J., Naughton, J.F.: Query Size Estimation by Adaptive Sampling. In: Proc. ACM PODS (1990)Google Scholar
- 7.Piatesky-Shapiro, G., Connell, C.: Accurate estimation of the number of tuples satisfying a condition. In: Proc. ACM SIGMOD Conference (1984)Google Scholar
- 8.SQL Server 2000 Books Online v8.00.02. Microsoft Corp. (2004)Google Scholar