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: How do i know Table Dependencies
Next Topic: Embedding Files into Oracle
Goto Forum:

Current Time: Sun Aug 20 06:51:30 CDT 2017

Total time taken to generate the page: 0.12898 seconds