Hints and Bind Variables
Published October 02, 2026
By Sai Sree Ram Gundepudi
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;