Re: Archive sizes

> Neil Truby wrote: > 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?! > When you delete data froma table, the pages used by that table are not free by the engine. You have to do an alter index on the table or unload the data and table schema, drop the table, create it again and then load the data back into the table. HTP Serafim Fonseca ========================================================================== Serafim Fonseca e-mail: sf@dpx20.growela.pt Growela Portuguesa Calcado, Lda. phone : +351 2 9820510 S. Pedro Avioso, Castelo fax : +351 2 9812212 4470 Maia - PORTUGAL