![[assets/ex_modifytable.png|256]] - **Description**: Handles insert, update, and delete operations. - **Performance**: Depends on type of modification (INSERT, UPDATE, DELETE). - **Factors**: Number of rows modified, indexes on the table. - **Cost**: `operation cost * number of rows` - ![[assets/ex_insert.svg|200x200]] ![[assets/ex_update.svg|200x200]] ![[assets/ex_delete.svg|200x200]] - **Operates on**: [[Structures/Page]] [[Structures/Tuple]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/DataFileWrite]] - [[Workloads/Sub/DataFileExtend]] - [[Workloads/Sub/DataFileSync]] - [[Workloads/Sub/WALWrite]] - [[Workloads/Lock]] - [[Workloads/Sub/relation]] - [[Workloads/Sub/tuple]] - [[Workloads/Sub/transactionid]] - [[Workloads/LWLock]] - [[Workloads/Sub/WALInsert]] - [[Workloads/Sub/BufferContent]] - [[Workloads/Sub/BufferMapping]] - [[Workloads/IPC]] - [[Workloads/Sub/SyncRep]]