Sciweavers

Share
ICDE
2000
IEEE

Automating Statistics Management for Query Optimizers

10 years 5 months ago
Automating Statistics Management for Query Optimizers
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.
Surajit Chaudhuri, Vivek R. Narasayya
Added 01 Nov 2009
Updated 01 Nov 2009
Type Conference
Year 2000
Where ICDE
Authors Surajit Chaudhuri, Vivek R. Narasayya
Comments (0)
books