公开(公告)号：US11847121B2

公开(公告)日：2023-12-19

申请号：US17458750

申请日：2021-08-27

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Daniele Costante Zilio ,  Muhammad Esaad Afaque ,  Darren Andrew Pepper ,  Xi Sun ,  Kostas Rakopoulos

IPC: G06F16/24 ,  G06F16/2455 ,  G06F16/2453

CPC classification number: G06F16/24561 ,  G06F16/2456 ,  G06F16/24535

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: obtaining a query statement; parsing the query statement and determining from the parsing that the query statement is a compound predicate query statement that includes a first predicate and a second predicate; responsively to the parsing, rewriting the obtained query statement to provide a transformed query statement, wherein the rewriting includes (a) specifying generating of a temporary table, wherein the specified generating uses data values of the first predicate and (b) specifying a join function that uses the temporary table and a table referenced in the query statement; evaluating a candidate access path associated to the transformed query statement; selecting the candidate access path as an access path for execution; and executing the transformed query statement according to the selected candidate access path for execution.