Re: 11.50.xC4 Compression with workgroup edition?

On Thu, May 21, 2009 at 1:02 AM, Fernando Nunes <domusonline@gmail.com>wrote: > > Finally a small note. The compression functionality introduced two other > "small" features that may be very useful. Repack and shrink. But that's a > bit > off topic. > > Regards. > Although this is off-topic and on the technical side I think it's worth to mention: The way it was implemented introduced two more features: REPACK and SHRINK You can check the documentation, but repack will reorganize the table... the data rows will move an in the end the table will have pages as full as possible and free allocated space at the end. This space can be freed with SHRINK. These features are available in Enterprise edition ans AFAIK and for the moment in WE. It's not available in Express edition. Customers can use this without buying the compression, or in restrict naming, the Storage Optimization Feature. So, independently of the compression itself, IDS 11.50.xC4 introduced the two functionalities above, which can be very useful (and they don't cost money where available (EE and eventually WE). Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...