When to Use a Direct Path Load

If none of the previous restrictions apply, then you should use a direct path load when:

  • You have a large amount of data to load quickly. A direct path load can quickly load and index large amounts of data. It can also load data into either an empty or nonempty table.

  • You want to load data in parallel for maximum performance. See "Parallel Data Loading Models".