Automating statistics management for query optimizers

Surajit Chaudhuri

doi:10.1109/69.908978

2001-01-01

PRE

Surajit Chaudhuri *

Narasayya, V

DOI：10.1109/69.908978

原文链接

原文求助

摘要

En 中文

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.

Keyword:

statistics

workload

query optimizer

query plan

AI总结

对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

IEEE Transactions on Knowledge and Data Engineering

IF:

10.4

论文数:

6.8K

被引数:

3.2W

机构

暂无机构信息

引用论文

Microfluidics and soft matter: small is useful

Soft Matter

IF0

2012-01-01

PREAI

Denis Bartolo; Dirk G. A. L. Aarts

The first samples from Almahata Sitta showing contacts between ureilitic and chondritic lithologies: Implications for the structure and composition of asteroid 2008TC₃

Meteoritics & Planetary Science

IF0

2019-10-15

OAAI

Cyrena Anne Goodrich; Michael E. Zolensky; Anna Maria Fioretti; Muawia H. Shaddad; Hilary Downes; Takahiro Hiroi; Issaku Kohl; Edward D. Young; Noriko T. Kita; Victoria E. Hamilton; My E. I. Riebe; Henner Busemann; Robert J. Macke; M. Fries; D. Kent Ross; Peter Jenniskens

Optical avalanche in Ho:Yb:Gd2O3 nanocrystals

Journal of Applied Physics

IF0

2011-08-16

PREAI

Y. Dwivedi; A. Bahadur; S. B. Rai

The expression of vascular endothelial growth factor and its receptors in port‐wine stains

Otolaryngology–Head and Neck Surgery

IF0

2008-10-01

PREAI

Emre Vural; Jeevan Ramakrishnan; Neslihan Cetin; Lisa Buckmiller; James Y. Suen; Chun‐Yang Fan