Multiple choice technology databases

You use comments in a SQL statement to pass hints to the Oracle optimizer

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle optimizer hints are embedded in SQL comments using the format /+ hint_name */ or /+ hint_name(table_alias) */. These comments are specially parsed by the optimizer to influence execution plans while remaining valid SQL comments.