Multiple choice technology performance

Usage of Hints is advisable in a SQL statement

  1. True

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

Using hints in SQL statements is generally not advisable because they hard-code optimization assumptions that may become outdated as data distribution changes. Hints should only be used as a last resort when the optimizer consistently makes poor choices and other tuning methods have been exhausted.

AI explanation

Optimizer hints override the query optimizer's own cost-based decisions, which is generally discouraged because it locks the execution plan to a specific strategy that may become suboptimal as data volumes, statistics, or indexes change over time. Best practice is to let the optimizer choose the plan and only resort to hints in rare, well-justified cases, so as a general practice it is not advisable.

Keep practicing — related questions