Xref: alice comp.databases.oracle.tools:39433
From: Gerald Kilgus <gerald.kilgus@merck.de>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Search Engine
Date: Wed, 02 Feb 2000 14:34:48 +0100
Organization: Merck KGaA SIS
Lines: 21
Message-ID: <38983278.10793D6D@merck.de>
References: <86e0g8$rl0$1@Masala.CC.UH.EDU>
Reply-To: gerald.kilgus@merck.de.nospam
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.6 [en] (WinNT; U)
X-Accept-Language: en
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.nacamar.de!newsfeed.arcor-ip.de!news-fra1.dfn.de!news.!Wolfgang.Reimann

Hi,
Oracle has got a thing called Intermedia Text (Context Option in earlier
versions) which
offers the possibility of creating a full text index on columns. That is of
course much faster
than doing for example a "like %string%". Check out technet.oracle.com for more
details.

Cheers
Gerald

Ying Yang wrote:

> I am trying to add a search feature to a internet application,
> the database is ORACLE. With up to a million records in some of the tables,
> the search takes extremely long time. I am wondering if ORACLE has some
> kind of search engine that can solve my problem?
>
> Thanks in advance,
> Paul