RE: CTX Indexes


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!




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



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.

select standard_disclaimer from company_requirements where category =


Other related posts: