Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to index only words with a minimum length

AleCOct 19 2009 — edited Oct 20 2009
RDBMS: 10.1.0.5.0

We are developing a search function into our application.

Users could search strings or substrings into a CLOB text. The minimum length of that strings or substrings is 3.
For example, they are able to search the string "sql" and they are NOT able to search "sq".

Is there a preference to not index all the strings with lenght below 3?
This post has been answered by Roger Ford-Oracle on Oct 19 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2009
Added on Oct 19 2009
#database-key-features, #text
5 comments
2,385 views