Hints and Bind Variables

Hints

Used to override default optimizer behavior.

SELECT /*+ INDEX(employees emp_idx) */ * FROM employees WHERE department_id = 10;

Bind Variables

Improve performance by reducing parsing.

SELECT * FROM employees WHERE department_id = :dept;