Description
If you chose delta mode for an index of a table, new data is not writtento the main index, but to the delta index. This can significantlyimprove performance during indexing. However, if the delta index becomesvery large, this can have a negative impact on performance when youexecute queries.
When the delta index reaches 10% of the main index, the system displaysa warning.

Repair
A MERGE is performed for these indexes in repair mode. The settings areretained.