Oracle Database Discussions

Dear Everybody,

I am a newbie in the world of oracle.

I HAD POSTED THIS SAME QUESTION IN SQL AND PLSQL CATEGORY, but thought i had posted in a wrong category so i am posting the same question here again.

Recently my Boss asked me one question regarding index usage.

He want to force the index to be used though the optimizer does not choose to use it.

But limitattion is that he canot touch the query or code because it is directly fired by an application whose code we cannot change.

So how can one force a query to use index without giving any hints.

It should be for particular query, it should not apply for all the indexes in the database.

I know one parameter "OPTIMIZER_INDEX_COST_ADJ". If you set this parameter properly you can force the optimizer to use the index.But it has its own limitations.

So i want an alternative to this option which can be applied only for a particular query without using hints.

As this is my first thread, sorry if i had made any mistake in posting the question

Thank you all in advance

Regards,
Navin Bandi