Ask the Expert

Function-based index or Oracle Text?

In this response, you suggest a function-based index. How will this help? Both queries produce a full table scan with a string search on each row? Oracle Text/Intermedia might be a better choice here.

    Requires Free Membership to View

With a function-based index (FBI) , there should be no full table scan (unless statistics haven't been gathered on the index so that it is available to the optimizer).

Oracle Text might be an alternative, but it requires considerably more setup. I'd test with the FBI before going that route.

This was first published in July 2006

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: