Hints can be used to direct query optimizer to use a specific optimization technique for a query and can override the OPTIMIZER_MODE initialization parameter for that SQL statement. For example

1

SELECT /*+ ALL_ROWS */ empno, ename FROM emp;

If a hint is incorrect or invalid, Oracle ignores the hint without causing an error.