Use of Indexes [message #271047] |
Fri, 28 September 2007 16:08 |
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 |
pablolee
Messages: 2882 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.
|
|
|
|
|