SQL & PL/SQL

hello all,

I am in the process of tuning a query. Now i want to fetch only 3k data from a table which has millions of data.

When i fetch its "using index(skip scan)" table scan so the cost will be around 73k.

But i hve a lot of conditions there i want it to choose index(unique scan) range scan,


Bcz previously i got the cost as only 64 that time the optimizer used "index(unique scan) range scan" only... so i want to get it back.

Any possible way of using "Oracle hint"? if so pls tell me..


and also let me knw that when will the optimizer choose "index(unique scan) range scan"?


Note: my table dont hve any constraints and indexes.