Skip to Main Content

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2005
Added on Aug 1 2005
14 comments
1,937 views