Table Fragmentation
IDS engines support the intelligent placement of tables across multiple disks or across multiple files on a disk. This is known as table fragmentation, and contrary to the terminology commonly used in computer systems, fragmentation in this case is a good thing. Fragmentation occurs at table create or table alter level. In the table creation statement the DBA can specify a scheme for placing the table data into different dbspaces based on certain conditions exhibited by the data.
There are two methods of table fragmentation:
Round-robin: This type of fragmentation attempts to evenly distribute all of the data across all of the listed dbspaces for the table. In a non-fragmented table that consists of multiple dbspaces, the ...
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.
