Re: Archive sizes

Neil If you've only deleted the data and not reorganized the table, then the table still "owns" the space and Informix still backs it up. You could try clustering an index on this table if you have the space, or unload it, drop it, create it, load it. This should free up the space and reduce the size of your backup. Davin ______________________________ Reply Separator _________________________________ Subject: Archive sizes Author: Neil Truby <ntruby@netcomuk.co.uk> at Internet Date: 1/28/97 2:56 PM What algorithim does OnLine use when creating archives? I have deleted a large amount of data from a main table in my application, then onubload/onloaded the database. I had expected to see the size of the archive drop substantially, perhaps from 1200MB to 800MB, but in fact the archive is not very much smaller. I expect that the table now has a large amount of unused pages allocated, but surely OnLine wouldn't dump these, would it? Would it?! Neil Truby Chase Bank Bournemouth, UK