Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
I am using informix 7.31. I have deleted rows from a big table and I
need to claim the space back that it was holding. What command can I
use without unloading and reloading the table.
alter anindex_from_that_table to cluster,
alter fragment on table <yourtable> init in .....
warning if the remaining table is huge then be aware of long trx
rollbacks
Superboer.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.