Invention Grant
US08135702B2 Eliminating unnecessary statistics collections for query optimization
有权
消除用于查询优化的不必要的统计数据集
- Patent Title: Eliminating unnecessary statistics collections for query optimization
- Patent Title (中): 消除用于查询优化的不必要的统计数据集
-
Application No.: US12290088Application Date: 2008-10-27
-
Publication No.: US08135702B2Publication Date: 2012-03-13
- Inventor: Louis M. Burger , Frank Roderic Vandervort
- Applicant: Louis M. Burger , Frank Roderic Vandervort
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Gates & Cooper LLP
- Agent Ramin Mahboubian
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method and system for eliminating unnecessary statistics collections for query optimization in a database stored on a computer. Statistics are unnecessary when a re-generated query execution plan that does not use the statistics is equivalent to an original query execution plan that uses the statistics. To determine this, an original query execution plan is created for each query in a specified workload using the statistics in the database. A search is performed of the statistics in order to enumerate one or more candidate sets of statistics to be eliminated. One or more of the candidate sets of statistics are removed from consideration prior to creating the re-generated query execution plan for each query in the specified workload. The re-generated query execution plan, which was created with one or more of the candidate sets of statistics removed from consideration, is compared with the original query execution plan, which was created using the statistics, in order to determine whether the re-generated query execution plan and the original query execution plan are equivalent. The one or more of the candidate sets of statistics removed from consideration are identified as unnecessary when the re-generated query execution plan and the original query execution plan are equivalent.
Public/Granted literature
- US20100106708A1 Eliminating unnecessary statistics collections for query optimization Public/Granted day:2010-04-29
Information query