Force oracle to use index
oracle
Solution
No. And if the optimizer doesn't use the index, it usually has a good reason for it. Index usage, if the index is poor, can actually slow your queries down.
Problem
Is there any way to force oracle to use index except Hints?