Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: interMedia indexes: how to speed up process

Re: interMedia indexes: how to speed up process

From: Sergey Sikorskiy <sergey_sikorsky_at_worldnet.att.net>
Date: Wed, 01 Aug 2001 04:45:59 GMT
Message-ID: <bQL97.22829$LP2.1428364@bgtnsc06-news.ops.worldnet.att.net>

"LR" <lrako_at_hotmail.com> wrote in message news:dcc2db96.0107300716.4f72af4d_at_posting.google.com...
> Hi all,
>
> We are using iFS out-of-the-box. So far, the search on Document
> content does not work as we did not create indexes.
>
> This we, we've created a basic interMedia index. The process took 48
> hours to index 4200 documents. It is quite a long time. Any hints to
> speed up that process (PARAMETERS, Memory)?
>
> Using NOLOGGING option of the create index does not work.

Did you tried common index creation optimization technique? Like tuning sort_area_size, sort_area_retained_size, redo logs tuning, disabling parallel query option.

Sergey Sikorsky Received on Tue Jul 31 2001 - 23:45:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US