Invention Grant
- Patent Title: Performance of SQL execution sequence in production database instance
-
Application No.: US17541322Application Date: 2021-12-03
-
Publication No.: US11847120B2Publication Date: 2023-12-19
- Inventor: Shuo Li , Xiaobo Wang , Min Li , Sheng Yan Sun
- 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
- Agency: Schmeiser, Olsen & Watts, LLP
- Agent Stephanie Carusillo
- Main IPC: G06F16/30
- IPC: G06F16/30 ; G06F16/2453 ; G06F11/34 ; G06F16/23 ; G06F16/2452

Abstract:
A method, computer program product, and computer system for improving performance of a SQL execution sequence of SQL statements. The SQL execution sequence is recorded in an event log. Original results of executing the SQL statements and an original CPU cost of executing the SQL statements in accordance with the original access path are recorded in a logical log. A new access path is generated from analysis of the event log and the logical log. The SQL statements are executed in accordance with the new access path resulting in new results of executing the SQL statements including a new CPU cost of executing the SQL statements in accordance with the new access path. In response to a determination that the new results replicate the original results and that the new CPU cost is less than the original CPU cost, the original access path is replaced with the new access path.
Public/Granted literature
- US20230177052A1 PERFORMANCE OF SQL EXECUTION SEQUENCE IN PRODUCTION DATABASE INSTANCE Public/Granted day:2023-06-08
Information query