Overflow Management
Overflow chains can slow down performance considerably. Overflow must be monitored and prevented as much as possible.
Preventing or reducing overflow requires you to do the following:
• Carefully monitor overflow in both primary tables and secondary indexes
• Avoid the use of repetitive keys, including both primary keys and secondary index keys
• Modify table structure to redistribute poorly distributed overflow
• Understand the overflow implications when choosing a particular storage structure