Ask the Expert

Using hints to force index use in PL/SQL

How can I use hints to force index use in PL/SQL?

    Requires Free Membership to View

Using a hint in PL/SQL is no different than using a hint in SQL. Depending on your version, your odds of success may be good or bad. Pre-Oracle 9i, the PL/SQL engine was different than the SQL engine so hints didn't always behave as expected in PL/SQL. One of the solutions was to write a view that encapsulated the hint and then have PL/SQL use that view, but that doesn't always work either.

This was first published in August 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: