Cost of Join Index Maintenance
The largest resource burden for any join index is incurred by its maintenance: inserting, updating, and deleting rows in the join index table. Similar to creation costs, various types of join indexes incur very different maintenance costs.
The time resources required to maintain a join index are described in “Maintenance Costs of Join Indexes” on page 476.