The INSERT, DELETE, and UPDATE statement interface
The following figure shows the order in which the database
server executes purpose functions to insert, delete, or update a row
at a specific physical address. The physical address consists of fragment
identifier and row identifier.Figure 1: INSERT, DELETE, or UPDATE by row address
The following figure shows the order in which the database
server executes purpose functions if the insert, delete, or in-place
update has an associated WHERE clause. Figure 2: INSERT, DELETE, or UPDATE in a subquery
The following figure shows the more complicated case in
which am_getnext returns multiple rows to the database
server. In either case, the database server calls am_insert, am_delete,
or am_update once per row. Figure 3: Returning multiple rows that qualify
for INSERT, DELETE, or UPDATE