index using in query plsql code example Example: index using in query plsql select /*+INDEX(e,dept_idx)*/ * from emp e;