Question: what are query hints in oracle?
Answer: Summary. An Oracle hint provides directive to the optimizer in choosing an execution plan for the SQL statement being executed. The Oracle INDEX hint instructs the optimizer to use an index scan for the specified table.