Invention Grant
- Patent Title: Access path for database optimizer
-
Application No.: US17121367Application Date: 2020-12-14
-
Publication No.: US12045235B2Publication Date: 2024-07-23
- Inventor: Shuo Li , Xiaobo Wang , Sheng Yan Sun , Hong Mei Zhang
- 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 Gavin Giraud
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F11/34 ; G06F16/21

Abstract:
In a computer-implemented method for improving performance of a database optimizer, a processor calculates a first execution time for a database query executing through a first access path of a database system. A processor generates a second access path. A processor determines a second execution time via a simulation of the database query through the second access path. A processor determines that the second execution time is less than the first execution time. A processor, responsive to determining that the second execution time is less than the first execution time, sends the second access path to the database optimizer.
Public/Granted literature
- US20220188314A1 ACCESS PATH FOR DATABASE OPTIMIZER Public/Granted day:2022-06-16
Information query