This section explains how to speed up the data manipulation
language (DML) statements,
INSERT
,
UPDATE
, and
DELETE
. Traditional OLTP
applications and modern web applications typically do many small
DML operations, where concurrency is vital. Data analysis and
reporting applications typically run DML operations that affect
many rows at once, where the main considerations is the I/O to
write large amounts of data and keep indexes up-to-date. For
inserting and updating large volumes of data (known in the
industry as ETL, for “extract-transform-load”),
sometimes you use other SQL statements or external commands,
that mimic the effects of INSERT
,
UPDATE
, and
DELETE
statements.