Re: fragmentation

One thing to note on fragmentation, it is always good practise to have objects with the same extent size in the same tablespace, this way you basically cannot have fragmentation... Unless you consider the fact that you have multiple extents belonging to one object, fragmentation.

now, tests have shown that the fact that a table has multiple extents does not necessarily degrade performance...(hardly ever does) also, it does not really matter whether all those extents are lined up or not, so I would not worry too much about having more than 1 extent per object, as long as you are not having problems allocating free extents because of different size extents...

hope this was clear, heh...

Wim Received on Fri Jan 23 1998 - 00:00:00 CST