Regular maintenance of the CSE tables and indexes, both after cleanup of unusable models and as a function of normal operations, is critical in ensuring that efficient accesses to CSE data are maintained. The frequency at which this maintenance is performed depends on factors such as the volume of use of the CSE and the volatility of the models in the CSE.
These factors also impact the growth rate and fragmentation of CSE tables and indexes. As objects are added to the CSE, table and index freespace will be reduced and space extents may be taken. This activity should be monitored and corrected, by reorganization and space reallocation, before performance is impaired.
|
Copyright © 2013 CA.
All rights reserved.
|
|