- 专利标题: ACCESS PATH FOR DATABASE OPTIMIZER
-
申请号: US17121367申请日: 2020-12-14
-
公开(公告)号: US20220188314A1公开(公告)日: 2022-06-16
- 发明人: Shuo Li , Xiaobo Wang , Sheng Yan Sun , Hong Mei Zhang
- 申请人: International Business Machines Corporation
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F16/2453
- IPC分类号: G06F16/2453 ; G06F16/21 ; G06F11/34 ; G06F16/2458 ; G06F16/25
摘要:
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.
公开/授权文献
- US12045235B2 Access path for database optimizer 公开/授权日:2024-07-23
信息查询