Hints and Bind Variables
Published July 26, 2025
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;