RE: CTX Indexes

Raj,

That makes sense.  So the resync gets the new records into the indexes
and the optimize cleans everything up.  I just tried and it looks like
optimize cleans up deletes, and resync does the inserts.

 

OK - thanks Raj!

 

Tom

________________________________

From: rjamya [mailto:rjamya@xxxxxxxxx] 
Sent: Wednesday, May 25, 2005 11:31 AM
To: Mercadante, Thomas F (LABOR)
Cc: Marquez, Chris; Peter.Hitchman@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: CTX Indexes

 

Tom,

We have a bunch of ctx indexes, some we sync every half hour, some every
hour. We optimize them weekly.  Everything is done through cron for us.

Raj
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';


--
http://www.freelists.org/webpage/oracle-l

Other related posts: