Multiple choice technology databases

Which are the commands used to improve the performance of loader

  1. direct=true

  2. command

  3. indexes

  4. constraints

  5. running multiple load jobs

  6. fast=true
Reveal answer Fill a bubble to check yourself
A,C,D,E Correct answer
Explanation

SQL*Loader performance can be improved by: (A) direct=true bypasses SQL processing for direct path loads; (C) managing indexes - you can skip index maintenance during load and rebuild after; (D) managing constraints - defer constraint checking until after load; (E) running multiple load jobs in parallel. Option B 'command' is not a performance parameter, and F 'fast=true' is not a valid SQL*Loader option.

Keep practicing — related questions