Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!elroy.jpl.nasa.gov!sdd.hp.com!caen!news.cs.indiana.edu!rutgers!rochester!kodak!music!sengillo
From: sengillo@Kodak.Com (Alan Sengillo)
Newsgroups: comp.databases
Subject: Question about Informix's alter command
Keywords: informix alter
Message-ID: <1991May7.142132.24212@kodak.kodak.com>
Date: 7 May 91 14:21:32 GMT
Sender: sengillo@isdc15 (Alan Sengillo)
Organization: Eastman Kodak Co., Rochester, NY
Lines: 17

-- 

Does anyone know if the alter command in Informix does anything else then just
alter the columns in a table?

I am maintaining a program that after it delete rows from the database it
does an alter on the table. It seems that the alter is being done just to
reclaim diskspace. The problem is the table is large ( > 1,000,000 rows) and
the alter takes over 45 minutes. I want to remove the alter command, but I
want to make sure that the command is not doing anything else then just
reclaiming diskspace. I do not need to reclaim the diskspace since the table
is constantly growing. The deletes are done to remove old data.


|     Alan Sengillo                        PHONE: (716) 726-9716 or 477-3503  |
|  Internet: sengillo@Kodak.Com                                               |
|  USMAIL: Eastman Kodak Co.,   Dept. 698, 2-1-EP,   Rochester NY, 14653-5108 |