Re: deleting rows physical

Posted in 1999

Octav Chiriac — Mon, 4 Jan 1999 19:04:59 +0200 (EET) — source: Informix-list mailing list archive (1991-1998)

WF Software wrote: >In article <76oegi$pci$1@news.online.de>, goermet@online.de (online) >wrote: > >> I have following problem: >> >> in my Informix database the tables growing every day. >> If I delete some rows, the pysical space of the table >> will not be smaller. How can I delete this rows physical >> from the table/database >> >> (Informix 4.1, Sinix) >> >> goermet >> >> >> >> >You don't need to worry about this, generally. The space used by the >deleted row will be re-used on the next insertion. > >Paul Watson # I don't suffer from >WF Software Ltd. # stress, I'm just >Tel. (+44) 1436 674729 # a carrier >Fax. (+44) 1436 678693 # >www.wfsoftware.co.uk If you do need to free up the space in your dbspace you could: 1. ALTER FRAGMENT ... INIT IN yourdbspace 2. Set the index to cluster Hope it helps, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com