Index Hint - How to make sure Oracle is not using Index?
448198Aug 1 2005 — edited Aug 1 2005Friends,
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?