US 11,960,463 B2
Multi-fragment index scan
Andreas Amler, Heidelberg (DE); Paul Willems, Heidelberg (DE); and Till Merker, Sandhausen (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on May 23, 2022, as Appl. No. 17/750,841.
Prior Publication US 2023/0376473 A1, Nov. 23, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/221 (2019.01); G06F 16/2228 (2019.01); G06F 16/24556 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising:
performing a multi-fragment index scan operation included in a query pipeline of a query accessing a database table, the multi-fragment index scan operation comprising a first index scan on a first chunk of a main fragment of the database table and a second index scan on a second chunk of a first delta fragment of the database table, wherein the first delta fragment holds new data not yet transferred to the main fragment; and
generating, for ingestion by a next operation in the query pipeline, a first partial result set by at least merging a first output of the first index scan on the first chunk of the main fragment of the database table and a second output of the second index scan on the second chunk of the first delta fragment of the database table.