Re: Creating Oracle Text Indexes

From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 9 Mar 2009 15:45:23 -0000
Message-ID: <MPG.241f49ea8b45e1889896ed_at_News.Individual.NET>

In article <49b01bca$0$90276$14726298_at_news.sunsite.dk>, sejprv_at_hotmail.com says...>

>
> hi Jeremy
>
> You should create a db job and optimize your index. There are several ways
> to do that, try google text dbms_job optimize and you will find some
> answers.
>
> Oracle has some undocumentet unsupporteded features !? in older version you
> could optimize the index online in standard edt.

We are on 10.2.0.3 - you say "undocumented unsupported" ?

>
> Never drop/recrate in production your maxmem size will never could do it
> better than optimize.

Could you elaborate?

> In our environment dr$ .. $i sometimes contains 100 mill records (poor ocr)
> And text/intermedia isent google when you combine with your master table.
>
> In our application we have a max hit value beside value for wildcard
> maxterm,
>
> exec ctx_ddl.optimize_index('ifs_text', 'FAST');
>
> exec ctx_ddl.optimize_index('ifs_text', 'FULL', maxtime);
>

OK am looking into the detail of this.

Thanks.

-- 
jeremy

Received on Mon Mar 09 2009 - 10:45:23 CDT