Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Interview Index problem
Hello DBAs,
"select empno,ename,sal,deptno from emp where deptno=10 and sal>1000"
in the query given above I have 2 b-tree indexes on deptno and sal and using CBO, pls tell me oracle will use which index and
why...................Received on Mon May 29 2006 - 15:23:39 CDT