Invention Grant
- Patent Title: Techniques for query statistics inheritance
- Patent Title (中): 查询统计继承技术
-
Application No.: US13722735Application Date: 2012-12-20
-
Publication No.: US09436733B2Publication Date: 2016-09-06
- Inventor: Rama Krishna Korlapati , Haiyan Chen
- Applicant: TERADATA US, INC.
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Schwegman, Lundberg & Woessner, P.A.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
Abstract:
Techniques for query statistics inheritance are provided. Statistics for a database are used to determine selectivity estimates for sparse joins and tables being joined together within a given query. These statistics are inherited up to the given query along with the selectivity estimates and provided to a database optimizer to use when developing query plans and selecting an optimal query plan for the given query.
Public/Granted literature
- US20140181075A1 TECHNIQUES FOR QUERY STATISTICS INHERITANCE Public/Granted day:2014-06-26
Information query
