11. Maintaining Storage Structures : Overflow Management
 
Share this page                  
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