The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.01 - January/February (2001 vol.13)
pp: 7-20
ABSTRACT
<p><b>Abstract</b>—Statistics play a key role in influencing the quality of plans chosen by a database query optimizer. In this paper, we identify the statistics that are essential for an optimizer. We introduce novel techniques that help significantly reduce the set of statistics that need to be created without sacrificing the quality of query plans generated. We discuss how these techniques can be leveraged to automate statistics management in databases. We have implemented and experimentally evaluated our approach on Microsoft SQL Server 7.0.</p>
INDEX TERMS
Statistics, workload, query optimizer, query plan.
CITATION
Surajit Chaudhuri, Vivek Narasayya, "Automating Statistics Management for Query Optimizers", IEEE Transactions on Knowledge & Data Engineering, vol.13, no. 1, pp. 7-20, January/February 2001, doi:10.1109/69.908978
20 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool