Multiple choice technology performance

The Oracle optimizer should be controlled in choosing the type of joins

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Modern Oracle optimizers are cost-based and generally choose the most efficient join methods based on statistics. Explicitly controlling join types (using hints) is rarely necessary and can degrade performance if not done carefully. The optimizer should be trusted unless there's a proven performance issue.

Keep practicing — related questions