Re: fragment question

Posted in 1998

Arun Shastry — Mon, 22 Jun 1998 12:49:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Michal Hajek wrote: > <snip> > But > b)... > fragment by expression > dat1 < (today - 365) in dbspace1, -- (rows "older" then 1 year) > remainder in dbspace2 > I don't think Informix allows this, even if it did, it's probably a bad fragmentationscheme. TODAY is a dynamic function and your fragmentation scheme depends on when you build the table. You are better off giving it a static expression that doesn't change with time. > 1) can be such expression used ? > 2) will the "old" rows move to dbspace1 without explicit update ? Nope. Fragmentation is fixed until you do an update or insert. > > > I suppose this will not work, but I'd like to be sure. > > Thanks, Michal > -- > -------------------------------------------------------------- > Michal Hajek mailto:hajek@nspuh.cz > Sprava NIS http://www.nspuh.cz > NsP Uherske Hradiste phone : voice +420 0632 529 204 > Purkynova 365 fax +420 0632 551 014 > 686 68 Uherske Hradiste Czech Republic > --------------------------------------------------------------