The following table summarizes key differences between Ingest, Import, and Load utilities:
|
Attribute
|
Import
|
Ingest
|
Load
|
|
Speed |
Slow: uses sequential insert statements |
Fast: uses parallel insert threads |
Very fast: writes formatted pages directly into table space containers |
|
Concurrency |
High: sometimes escalates to table-level lock |
Very high: row-level locking |
Low: allows read-only operations |
|
Transaction logging |
Every record change is logged |
Every record change is logged |
Very minimal logging |
|
Behavior on failure |
Rollback, and table is accessible |
Rollback, and table is accessible |
Table will remain in Load Pending state |
|
LOBs and XML data |
Supported data type |
Unsupported data type |
Supported data type |
|
Utility type |
Server-side |
Client-side |
Server-side |
|
Triggers... |