how to pass a hint for query which fetches data from multiple tables

[kanthbethi]

very nice, but if i use empno index then there is no empno index on bonus table so it does a full table scan on bonus table.
I'm usnig something like this:
ex:
select /*+ index (emp EMPNO)*/e.ename, d.dname, b.comm from
emp e, dept d, bonus b
where e.deptno=d.deptno
and e.ename=b.ename
and b.comm<2000;

It does a index scan on emp but full scan on bonus.

Regards

raj