Avoiding and Curing Unplanned Table Fragmentation
There are several practices that you can follow to eliminate and cure unplanned table fragmentation. It is important to realize the difference between planned and unplanned fragmentation. Planned fragmentation occurs when the DBA makes a purposeful decision to locate various chunks of the table on different disk devices to improve disk access performance. This type of fragmentation is a feature of the IDS engine that was enacted to enhance the DBA's ability to intelligently locate disk chunks and indexes for top performance.
Unplanned fragmentation can happen with either OnLine or IDS engines. This happens when the engine is forced to allocate extents for a table in such a way that they are not ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
