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?

Original source