Question
Which technique most directly improves insertion speed for a very large warehouse batch?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Use set-based bulk loading with appropriate minimal logging and index strategy
Explanation:
Bulk, set-based operations reduce per-row overhead and exploit database throughput.
Indexes and constraints may need planned handling without sacrificing correctness.
Leave a Reply