8.2.5 Optimizing Data Change Statements优化数据更改语句

8.2.5.1 Optimizing INSERT Statements优化INSERT语句
8.2.5.2 Optimizing UPDATE Statements优化UPDATE语句
8.2.5.3 Optimizing DELETE Statements优化DELETE语句

This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. 本节介绍如何加速数据更改语句:INSERTUPDATEDELETETraditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is vital. 传统OLTP应用程序和现代web应用程序通常会执行许多小型数据更改操作,其中并发性至关重要。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. 数据分析和报告应用程序通常运行同时影响多行的数据更改操作,其中主要考虑的是写入大量数据并保持索引最新的I/O。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.为了插入和更新大量数据(在业界称为ETL,用于“提取-转换-加载”),有时您会使用其他SQL语句或外部命令,模拟INSERTUPDATEDELETE语句的效果。

8.2.5.1 Optimizing INSERT Statements
8.2.5.2 Optimizing UPDATE Statements
8.2.5.3 Optimizing DELETE Statements