| Operation | Comment | Plan operation |
| Conventional insert | Oracle tries to (re-)use free space. Referential integrity is maintained | LOAD TABLE CONVENTIONAL |
| Direct-path insert | Data is inserted beyond the table's high water mark. The buffer cache is bypassed. Generation of redo and undo data can mostly be turned off, which helps improve performance. | LOAD TABLE AS SELECT |