Q299. What are Optimizer Hints and when are they used?

Answer

Hints guide optimizer to choose specific plan.

Example:

SELECT /*+ INDEX(emp idx_empno) */ * FROM emp WHERE empno=101;

Used only when:

• Optimizer plan is wrong
• Emergency production tuning needed