Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Anyone used OMNIDEX to speed up contains searches (%term%)??
Thats great news....thanks very much.
Dave
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:utgc9t8u8snio77r6giessvr6quisimh4a_at_4ax.com...
> On Fri, 23 Feb 2001 10:18:51 -0000, "Dave Sutton"
> <dpsutton_at_marchsystems.co.uk> wrote:
>
> >Hi,
> >
> >We need to get faster performance on 'contains' searches of the form
> >%searchterm% which of course require a full table scan.
> >
> >Somebody a while ago suggested looking at full text search plug-ins such
as
> >those provided by OMNIDEX. My fear is that I would have to rewrite my
> >applications to channel certain queries through an API which is really
not
> >an option for me. Am I correct?
> >
> >Is there anything out there that will provide greater search performance
> >without the need to submit queries through a different interface?
> >
> >I noticed that the latest Microsoft SQL Server offering included a full
text
> >search capability - does Oracle 8 include a similar facility?
> >
> >
> >I'd appreciate any help or advice you can provide.
> >
> >
> >Dave Sutton
> >
>
> Oracle 8(i) *enterprise* comes with Intermedia. This addresses text
> search, blob search and searches for similar data.
>
> Hth,
>
>
> Sybrand Bakker, Oracle DBA
Received on Fri Feb 23 2001 - 11:44:26 CST