Invention Grant
- Patent Title: Access path optimization through system statistics
-
Application No.: US14798537Application Date: 2015-07-14
-
Publication No.: US10242058B2Publication Date: 2019-03-26
- Inventor: Hao Feng , Shuo Li , ShengYan Sun , Xin Ying Yang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Christopher K. McLane; Daniel R. Simek
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
In an approach for calculating one or more access paths during bind time, a computer receives a query. The computer identifies one or more access paths for processing the received query, wherein the one or more access paths include steps associated with retrieving data from a database based on the received query. The computer calculates resource costs associated with processing the received query on the one or more identified access paths based on one of more of: resources utilized to perform steps associated with processing the received query, and system statistics associated with the one or more identified access paths.
Public/Granted literature
- US20170017686A1 ACCESS PATH OPTIMIZATION THROUGH SYSTEM STATISTICS Public/Granted day:2017-01-19
Information query