Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
2005 Winter TopTen Award Winners, Winter Corporation (2005)
Ault, M., Tumma, M., Liu, D., Burleson, D.: Oracle Database 10g New Features: Oracle 10g Reference for Advanced Tuning and Administration. Rampant TechPress (2003)
Chaudhuri, S., Motwani, R., Narasayya, V.: Random Sampling for Histogram Construction: How much is enough? In: Proc. ACM SIGMOD Conference (1998)
DB2 Universal Database for iSeries – Database Performance and Query Optimization, IBM Corp. (2002)
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)
Lipton, R.J., Naughton, J.F.: Query Size Estimation by Adaptive Sampling. In: Proc. ACM PODS (1990)
Piatesky-Shapiro, G., Connell, C.: Accurate estimation of the number of tuples satisfying a condition. In: Proc. ACM SIGMOD Conference (1984)
SQL Server 2000 Books Online v8.00.02. Microsoft Corp. (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Sreenivasan, S., Zhou, X.M., Loh, T.K. (2006). Intelligent Statistics Management in Sybase ASE 15.0. In: Li Lee, M., Tan, KL., Wuwongse, V. (eds) Database Systems for Advanced Applications. DASFAA 2006. Lecture Notes in Computer Science, vol 3882. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11733836_51
Download citation
DOI: https://doi.org/10.1007/11733836_51
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-33337-1
Online ISBN: 978-3-540-33338-8
eBook Packages: Computer ScienceComputer Science (R0)