Re: Informix data fragmentation or RAID disk

Ben Van Truong (ben.truong@amd.com) wrote: : We are about to upgrade our Informix system to 7.11UC1. One of feature : provided by Informix 7.x is the capability to partitioning the table into : multiple dbspaces. I am hoping to use this feature to improve I?O performance. : What I am not sure is how the Informix table fragmentation works in conjunction : with hardware striping using RAID devices. Your comment, suggestion is greatly : appreciated. Hi! Still there is a perfomance problem with fragmented tables (even on 7.11UC1). When you have an ORDER BY clause in a query (on an indexpath or not) it creates a temporary table to sort which is very very slow on large tables. So if you are using ORDER BY think twice before you fragment them. Dhammika