Re: fragment by expression question

From: "MATTHEW H. DEVLIN" <the_griffon@my-deja.com> > >can anyone offer any input on this expression? is there any reason we >should not use it? We are doing it this way to essentially get round >robin type distribution but allowing the optimizer to do fragment >elimination. > > FRAGMENT BY EXPRESSION > (mod(ia_group_id,5) = 0) IN db1, > (mod(ia_group_id,5) = 1) IN db2, > (mod(ia_group_id,5) = 2) IN db3, > (mod(ia_group_id,5) = 3) IN db4, > (mod(ia_group_id,5) = 4) IN db5; This is perfectly valid, and is recommended by Informix for the very reason you want to use it. So that must be what's wrong with it. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com