Sciweavers

Free Online Productivity Tools i2Speak i2Symbol i2OCR iTex2Img iWeb2Print iWeb2Shot i2Type iPdf2Split iPdf2Merge i2Bopomofo i2Arabic i2Style i2Image i2PDF iLatex2Rtf Sci2ools

31

ICDE
2000
IEEE

favoriteEmaildiscussreport

89views Database» more ICDE 2000»

Automating Statistics Management for Query Optimizers

14 years 5 months ago

Automating Statistics Management for Query Optimizers

Download research.microsoft.com

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

Real-time Traffic

Database | Database Query Optimizer | ICDE 2000 | Microsoft SQL Server | Query Plans |

claim paper

Related Content

» A Learning Optimizer for a Federated Database Management System

» Automated Statistics Collection in DB2 UDB

» Automated SQL tuning through trial and sometimes error

» Using AspectOrientation to Manage Database Statistics

» Statistical Learningbased Automated Healing Application to mobility in 3G LTE networks

» On the Automation of Similarity Information Maintenance in Flexible Query Answering System...

» Deriving predicate statistics in datalog

» Automated statistics collection in action

» Enhancing RRM optimization using a priori knowledge for automated troubleshooting

Post Info
More Details (n/a)

Added	01 Nov 2009
Updated	01 Nov 2009
Type	Conference
Year	2000
Where	ICDE
Authors	Surajit Chaudhuri, Vivek R. Narasayya

Comments (0)