Oracle Partition - Data Load
Table of Contents
About
Data Loading with partitions.
Articles Related
Methods
Direct Insert
Taking advantage of partitioning for fact tables reduces index and statistics maintenance time during ETL processes.
Because the majority of inserts and updates impact the last partition(s), you only need to:
- disable local indexes on a few impacted partitions,
- and then rebuild disabled indexes after the load
- and then compute statistics on updated partitions only.
Partition Exchange
Index disabling/Re-enabling
The below procedure
- disabling an index,
- doing a large bulk load,
- re-enabling and rebuild the index
can be faster than “leaving the index in place during the load”
This is true for single partition tables (normal tables) as well as partitioned tables.
However, during the load, the indexes are “not there (not usable)” for query.