| 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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
