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;