RE: CTX Indexes

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: "rjamya" <rjamya@xxxxxxxxx>
  • Date: Wed, 25 May 2005 11:34:51 -0400


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: