RE: Fragmentation by expression

You could calculate the week in your program and have an integer or short field be the week #. Then use this for your fragmentation strategy. Advantages: 1. Parallel fragment scans. 2. Fragment elimination if you are able to calculate the week number for the query. 3. Easy to purge a week of data.(detach, drop, readd fragment) 4. If fragments are loaded by week you are loading into an empty table, as opposed to having to find holes in the current table to insert your data into. Disadvantages: 1. To get fragment elimination you have to calculate the week number. 2. You are only writing to one dbspace if you are adding records by week. This is what I came up with off the top of my head. We have implemented a similar scheme and have been fairly happy with the results. Will >===== Original Message From benlag@my-deja.com ===== >I have an Informix DS 7.30 UC9-1 on a HP-UX 10 box. I want to implement >fragmentation on a table but want to split it up according to what week >number a date in the table falls in. Can this be done or am I attempting >the impossible?? > >Any help or suggestions would be greatly appreciated, > >Benny Lago >Alliance Entertainment, Inc. > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------