Multiple choice technology databases

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

  1. False

  2. This is hard to determine

  3. True

  4. None of the choices
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle does support using comments to pass optimizer hints. These are specially formatted comments that tell the optimizer how to execute a query - for example, /*+ INDEX(table index_name) */ hints which index to use. This is a documented Oracle feature.

Keep practicing — related questions