Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gmail.com]
Sent: Wednesday, May 25, 2005 11:31 AM
To: Mercadante, Thomas F (LABOR)
Cc: Marquez, Chris; Peter.Hitchman_at_thomson.com; oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 11:39:40 CDT