| how to use index es in execution [message #65329] |
Sat, 07 August 2004 22:51  |
Ravikumar.V
Messages: 26
Registered: July 2004
|
Junior Member |
|
|
Sir
After creating index, internally it is performing
the execution.
if we want to execute index in the select stm
how to give
can we use following query
select /*+ index name*/ < column name > from
;
ie., can we use hint to execute index.
or how to see the index execution.
|
|
|
|
| Re: how to use index es in execution [message #65332 is a reply to message #65329] |
Mon, 09 August 2004 12:06  |
SK
Messages: 26
Registered: March 2001
|
Junior Member |
|
|
What exactly is your question, from what i gather
there are 2 aspects to your question:
Do you want to force the optimizer to use the index that you have created, in that case you can give the hint.
If you want to see if the index is being used then
you can you tools like explain plan to check if the index is being used by the optimizer
Hope this helps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
