RE: CTX Indexes
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: "rjamya" <rjamya@xxxxxxxxx>
- Date: Wed, 25 May 2005 11:34:51 -0400
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';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
