Oracle tuning: Using Hints
Monday, June 20th, 2005Every once in a while you will get a query that no matter what you try, it doesn't use the indices. This is typically because the cost-based optimizer decides that an approach that is slower has a total cost that is lower than using the index and making it faster.
To solve this, you would use a hint. You can find an article on how to do this on dbasupport. But the basics are: (more...)