Home > IT Answers > Oracle > Oracle ignores hints
Sueterrin
5 pts.
 Oracle ignores hints
hints, Oracle 10g
Oracle 10g does full table scan when he should use index specified in HINT

Software/Hardware used:
ASKED: August 21, 2008  3:49 PM
UPDATED: September 4, 2008  2:19 PM
RELATED QUESTIONS
Answer Wiki:
Hello Sueterrin. 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. Regards,
Last Wiki Answer Submitted:  September 3, 2008  3:17 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Also in your INDEX hint make sure you use the alias in your query, if you have one. If you are using an alias and specify the table name, Oracle will ignore the hint.

Dwaltr
 900 pts.