Re: Fragmentation opinion wanted.

There are two things you try to achieve with fragmentation: 1. Parallelism 2. Fragment elimination Since hardware likely doesn't know what the data looks like, it isn't going to be much help with either of those. It doesn't mean you can't use hardware to help distribute I/O...but it can probably be better used with an effect Informix fragmentation strategy. I can provide a couple of examples if you'd like... --Chuck On Thu, 9 Mar 2000, Paul Howard wrote: > We have IDS 7.31 and AIX 4.3 > > I am being told by my software vendor that I should not fragment tables using > Informix > fragmentation. They say that it would be better for me to optimize my system by > spanning dbspaces across multiple disks and letting the hardware fragment the > table. > > This is contrary to my experince and schooling. Can anyone tell me how much merit > this > statement of my software vendor has?