Re: Defrag large fragmented table in 7.32
Posted in 2006
Curtis Crowson — — source: Usenet: comp.databases.informix
John Carlson Said> >Would this be a good feature request . . . . online reorgs?? I am all in on this. Of course if it is a new feature then someone running 7.31 couldn't take advantage of it. Although, This might lead to people upgrading. I believe IBM has expressed some interest in people upgrading to 10.x products. ;-) Maybe the ER code can be used to implement this quickly. An online reorg could be translated to the following inside of Informix: replicating a table to the same instance and database with a different name and then exchanging old and new table names and then dropping the old table. It doesn't actually have to be fast since the table is always online. You just of course need the extra space to do it in.