Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Context-Cartridge with Oracle 8.0.5.2.0
Sounds like an ideal case for using the context cartridge to me. It sounds
as though you would have a farely simple text index that could be queried
simply using a one step query, but it will depend on the overall nature of
your query structures. Depending on the nature of your data, the context
index should be smaller than a normal index, but you will have the overhead
on the processor/s of running the various context servers to support
querying and dynamic updates to the index (if that is how you want to do
it - you can also batch the updates).
Your scenario sounds simple, I would give it a go and see what the performance implications are.
HTH Rod J. Stewart
Karl R. <kreitsch_at_zdnetmail.com> wrote in message
news:11f733ec.c783e5c1_at_usw-ex0102-012.remarq.com...
> Hello !
>
> We have a Table with 1 million rows with a text-field ( 80 char ) and
> querying full-text with the like-operator. Searching something like
> '%XY%' causes a fulltable-scan.
> Is this a case for the context-cartridge?
> and how could it be used?
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Nov 22 1999 - 23:15:22 CST