Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Interview Index problem

Interview Index problem

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 29 May 2006 13:23:39 -0700
Message-ID: <1148934219.754175.228340@j33g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US