bruce@zeb.USWest.COM (Bruce W. Hoylman) (10/28/89)
An Informix Question: I have a table of significant size (~15MB). I archived all unused data from it via selective SQL scripts and was able to remove over 4000 rows. To my dissappointment the physical size of the file did not shrink in the least. Apparently the SERIAL datatype of a column within this table prevents the numbering sequence of the column from being anything but sequential and thus when a row is marked as deleted Informix cannot remove its actual place in the sequence as it would disrupt the numbering series. Is this the case? Is there a cure? I realize I could dump the data in the table, recreate it and reload but I would end up renumbering the data records with new SERIAL values (wouldn't I?). Anyway, any suggestions? I appreciate the information (in advance). You can reply via e-mail and I will summarize if there's enough response. Later ... Bruce W. Hoylman (303-889-5806) -- Standard disclaimer: "These views are bruce@mirage.USWest.COM probably my own ..." -- ncar!boulder!uswat!bruce