发明名称 |
Adaptive query execution plan enhancement |
摘要 |
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. |
申请公布号 |
US8645356(B2) |
申请公布日期 |
2014.02.04 |
申请号 |
US201213431981 |
申请日期 |
2012.03.28 |
申请人 |
BOSSMAN PATRICK D;COTNER CURT L.;FUH YOU-CHIN;PANNU ADARSH R.;REN KUN PENG;INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
BOSSMAN PATRICK D;COTNER CURT L.;FUH YOU-CHIN;PANNU ADARSH R.;REN KUN PENG |
分类号 |
G06F7/00;G06F17/30 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|