Multiple choice technology

To optimize the performance of a relational target which of the following can be done?

  1. Use normal loading

  2. Maximize deadlocks

  3. Decrease checkpoint intervals

  4. Use external loading
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

External loading (also called bulk loading or direct path load) bypasses normal SQL processing and the database logs, writing data directly to data files. This is significantly faster than normal loading for large datasets. The other options either describe standard behavior (normal loading) or degrade performance (deadlocks, frequent checkpoints).

Keep practicing — related questions