How to use Index Hint

Example: Syntax for index hint

select /*+ index(emp dept_indx) */ * from emp
where deptno=20;

 
If you use alias then you need to use it in hint:


select /*+ index(e dept_indx) */ * from emp e
Where deptno=20;

Comments