Alter Table Too Slow
Posted in 1994
Mike Mstowski — — source: Informix-list mailing list archive (1991-1998)
I am doing an alter table on a large table(75,000 rows, each row 500 bytes, and 8 indexes) using Informix Online 5.0 on HP/UX 9000/800 series coumputer. I'm adding a column to the table. I probably should have dropped the indexes before such a task but I forgot to do so. The program is now running for 6 hours and don't know if: 1) I should kill the program. (What problems might occur if I do this?) 2) Let if run. (How much longer might this run?) 3) Will I run out of any resources and how can I tell which ones? Thanks In Advance! Michael Mstowski mstowski@seas.gwu.edu