Re: Enough of the "DB2" thread, let's talk about Fragmented Tables

Colin Dawson wrote: > With the use of SANs for storing the database how effective will the use of > fragmented tables be? I've got a few very large tables (16+ chunks) and was > considering splitting it into 6-8 fragments, they all have serial columns > and one has 7 indexes (or is it indeces). The last time I did anything real > with them was splitting a table across 4 disks, it improved the performance > no end. I'm not convinced I will get an improvement when using a SAN > > > > Regards > > Colin > > > There are 10 types of people in the world, those that understand binary and > those that don't > > > sending to informix-list If the database kernel treats framents in Informix the same way that Oracle treats partitions the storage array is irrelevant to the improvement in performance you will see. The question is whether queries are pruned to only look at specific fragments and their associated indices. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)