SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index Hint - How to make sure Oracle is not using Index?

448198Aug 1 2005 — edited Aug 1 2005

Friends,

Is there any way I can mention in the hint to exclude the indexes?
There are few indexes on my fact table that are making the performance slow.

For one column, the distinct records are more than 80 %. So I think there shouldn't be an index on this column. How can I put this in hint?

Also the rownum is also indexed. This shouldn't be indexed. How can I exclude these two columns not to use index?

Anyone can help please?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2005

Added on Aug 1 2005

14 comments

2,028 views