Page History

Each time an OracleText full-text index is synchronized, the index becomes more fragmented. The higher the index fragmentation, the worse the search performance becomes. Index fragmentation is unavoidable in a live database where records are actively created, updated and deleted. The rate at which the index fragmentation increases depends on the index synchronization setting and the rate at which records are created, updated or deleted.  
 

Monitoring the index fragmentation

To obtain statistics about the full-text index execute a script similar to the following:

...

• the less frequently an index is synchronized, the more it takes for changes to aggregates and documents to be available through full-text search
• the more frequently an index is synchronized, the faster the index fragments and performance degrades

Optimizing the full-text index

A fragmented index can be optimized in two ways:

...