Home » Server Options » Text & interMedia » Text based search
Text based search [message #76041] Tue, 22 April 2003 21:52 Go to next message
Messages: 68
Registered: December 1999
I have a 80 character Name field in my customer table. My table contains
more 500,000 records. I want to search on any portion of the name field.
When I use the %search text% option, the search is taking a long time. I have tried the Inter Media text based index. Even there a %word% search is taking a long time. Is there an alternative ?
Re: Text based search [message #76043 is a reply to message #76041] Mon, 12 May 2003 17:19 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
If you want your query to use the interMedia index, you do not use the LIKE '%word%' syntax. There is a special function (CONTAINS) that you use instead.

where contains(name, 'word') > 0
Previous Topic: Embedding Files into Oracle
Next Topic: Oracle InterMedia Text
Goto Forum:

Current Time: Wed Aug 12 19:29:39 CDT 2020