Home » RDBMS Server » Performance Tuning » how to use index es in execution
how to use index es in execution [message #65329] Sat, 07 August 2004 22:51 Go to next message
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 Go to previous message
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
Previous Topic: Performance Tuning Tool
Next Topic: shared memory proble
Goto Forum:
  


Current Time: Thu Mar 28 11:11:34 CDT 2024