
Chapter 4. Search index life-cycle management 95
TI_DELTA_CATENTRY table, no further U entries are recorded until the F entry is cleared.
The F entry is only cleared after performing a full re-indexing. Remember, therefore, when
making updates to the catalog, if the re-indexing window that is scheduled is only large
enough to perform a delta update, leave the changes that cause an F update until later.
Perform full re-indexing periodically even if there is not an F requiring a full index build in the
TI_DELTA_CATENTRY table. When many delta updates have been made to an index, without
any full index builds, the index can start to degrade due to ...