Oracle ignores hints

5 pts.
Tags:
hints
Oracle 10g
Oracle 10g does full table scan when he should use index specified in HINT

Answer Wiki

Thanks. We'll let you know when a new response is added.

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,

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dwaltr
    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.
    900 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following