Home » Other » Training & Certification » Use of Indexes
Use of Indexes [message #271047] Fri, 28 September 2007 16:08 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
Hello Team,

I have a composite index on a table emp(id,name)
I am trying to do the following select

select * from emp where id =100 ;

Does it make use of the index

2) CAn we have index on a nested table



Thanks
Binu
Re: Use of Indexes [message #271051 is a reply to message #271047] Fri, 28 September 2007 18:00 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
Does it make use of the index
Yes, No, Maybe. You tell us. Look at the explain plan.
2. Read the documentation, search the web.
Re: Use of Indexes [message #271068 is a reply to message #271047] Fri, 28 September 2007 23:06 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
http://oraclelon1.oracle.com/docs/cd/B14117_01/server.101/b10752/data_acc.htm#2174
Re: Use of Indexes [message #271124 is a reply to message #271047] Sat, 29 September 2007 12:35 Go to previous message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
2) Yes.
Previous Topic: referential integrity
Next Topic: Comparing date from select statement
Goto Forum:
  


Current Time: Sun Dec 04 00:35:17 CST 2016

Total time taken to generate the page: 0.04993 seconds