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 |