I don't think Oracle ignore hints. I think there must be something else causing this behavior.
Optimizer hints does not cause syntax erors, so if the hint is not properly written there is no error, but the hint is ignored. It is also important to check whether the specified index exists and is really usable for the query being issued.
Last Wiki Answer Submitted: September 3, 2008 3:17 pm by carlosdl63,535 pts.