select /*+ index(emp EMPNO) index(bonus comm) */
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;


Not that i think it's a good idea, mind.