公开(公告)号：US20170177669A1

公开(公告)日：2017-06-22

申请号：US15259462

申请日：2016-09-08

Applicant: International Business Machines Corporation

Inventor： Shuo Li ,  Ping Liang ,  Ke Wei Wei ,  Xin Ying Yang ,  Chen Xin Yu

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30327 ,  G06F17/30463 ,  G06F17/30471

Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and a record identifier (RID) results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.