Invention Grant
- Patent Title: Adaptive query execution plan enhancement
- Patent Title (中): 自适应查询执行计划增强
-
Application No.: US13431981Application Date: 2012-03-28
-
Publication No.: US08645356B2Publication Date: 2014-02-04
- Inventor: Patrick D Bossman , Curt L. Cotner , You-Chin Fuh , Adarsh R. Pannu , Kun Peng Ren
- Applicant: Patrick D Bossman , Curt L. Cotner , You-Chin Fuh , Adarsh R. Pannu , Kun Peng Ren
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
An adaptive query execution plan enhancement is provided by: selecting a sample of literal sets from an execution history of a query statement; determining a plurality of access paths by applying each literal set in the sample to the query statement; for each given access path of the plurality of access paths, determining a total execution cost by applying each literal set in the sample to the given access path; and selecting a preferred access path from the plurality of access paths based on the total execution costs for each given access path. A plurality of preferred access paths for a plurality of query statements in an application workload is collected and may be presented as a query execution plan enhancement recommendation to users.
Public/Granted literature
- US20130262435A1 ADAPTIVE QUERY EXECUTION PLAN ENHANCEMENT Public/Granted day:2013-10-03
Information query