Hi all,
I have created the hint for my table index like
select \* +index (a emp) */ empno,empname
from emp a;
Now i want to know shall i give two hint in my select statement
ex:
select \* +index (a emp) */ empno,empname
from emp a,dept b
where deptid =:b1
and a.empid=b.empid;
for the above code i used the hint for emp table . it is possible to add the hint for dept table also.
if it is possible how to add two index hint in the single select statement.
Thanks
San.