Ansicht
Dokumentation

ABENSELECT_HIERARCHY_ABEXA - SELECT HIERARCHY ABEXA

SELECT, Hierarchy Generator, BULK vs. INCREMENTAL

This example demonstrates how the addition LOAD INCREMENTAL can speed up the generation of a hierarchy.

Source Code

Execute

Description

The table DEMO_GUID_HIERA serves as data source for a hierarchy. The user can enter how many rows in total are inserted, and how many of them are part of the hierarchy. Then, the table is filled with GUIDs and the rows that build a hierarchy tree are chosen randomly.

Based on this table, a hierarchy is generated, once with the addition LOAD BULK and once with LOAD INCREMENTAL. The time of hierarchy generation, which is done in DO-loops with 10 repetitions, is measured and compared.

When using the default values for the formal parameters, LOAD INCREMENTAL is many times faster than LOAD BULK. This positive effect is minimized when the total number of rows is decreased and the number of rows that are part of the hierarchy is increased.