本节解释了如何加速数据更改语句：INSERT、UPDATE 和 DELETE。传统的 OLTP 应用程序和现代 Web 应用程序通常执行许多小规模的数据更改操作，此时并发性非常重要。数据分析和报表应用程序通常执行会影响多行的数据更改操作，其主要考虑因素是写入大量数据的 I/O 以及保持索引的最新状态。对于插入和更新大量数据（在业内称为 ETL，即“extract-transform-load”）时，有时会使用其他 SQL 语句或外部命令，来模拟 INSERT、UPDATE 和 DELETE 语句的效果。This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is vital. Data analysis and reporting applications typically run data change 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.