12 Conventional and Direct Path Loads

SQL*Loader provides a conventional path load method and a direct path load method. Further information about each method is provided in the following topics:

• Data Loading Methods

• Conventional Path Load

• Direct Path Load

• Using Direct Path Load

• Optimizing Performance of Direct Path Loads

• Optimizing Direct Path Loads on Multiple-CPU Systems

• Avoiding Index Maintenance

• Direct Path Loads_ Integrity Constraints_ and Triggers

• Parallel Data Loading Models

• General Performance Improvement Hints

For an example of using the direct path load method, see case study 6, Loading Data Using the Direct Path Load Method. The other cases use the conventional path load method. (See "SQL*Loader Case Studies" for information on how to access case studies.)