MERGE Support for Load Isolated Tables
A nonconcurrent load isolated merge delete operation on a load isolated table physically deletes the matched rows. A nonconcurrent isolated merge update operation on a load isolated table updates the matched rows in-place.
A concurrent load isolated merge delete operation on a load isolated table logically deletes the matched rows. A concurrent load isolated merge update operation on a load isolated table logically deletes the matched rows and inserts the rows with the modified values. The rows are marked as deleted and the space is not reclaimed until you issue an ALTER TABLE statement with the RELEASE DELETED ROWS option. See SQL Data Definition Language Syntax and Examples.