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.
|
Results 1 to 7 of 7
Threaded View
|
Click Here to Expand Forum to Full Width |