Re: table extents cleanup

In article <4rre4b$ffq@cssun.mathcs.emory.edu>, mailgw!hpx400!Trevisol_R oberto/bbb_cak@srv3-poa.nutecnet.com.br writes >}-- Mark Blum (markb@raysfood.com) Wrote: >} >}>> We use Informix Online 5.05. Does anyone know of 3rd party software or >}>> another way of doing table extents cleanup. We are currently using >}>> dbschema and unloading to a file, re-creating the table with larger >}>> numbers then re-loading the table. >} >}I don't know if this works for Online 5, but creating a clustered index >}(or altering an existing index TO CLUSTER) will reconstruct the table >}into a single extent, if possible. This is a nice trick, since it even >}works on the system tables. Just drop the index (or alter to NOT CLUSTER) >}when done. >}Paul Kapp ----> PLKapp@aol.com -OR- plk@interactive.visa.com >} >The problem with the cluster index approach is: you have to have a lot of >free space in your dbspace in order to accomplish that. > >Why don't Informix provide us DBAs an utility to reorganize tables (or >dbspaces) ? I've got to deal with this stuff often in volatile tables. > >Roberto Trevisol >rtrevisol@bamerindus.com.br > Users very rarely have tables without indicies on and usually the main index is a cluster index for performance reasons. Therefore creating a few short SQL scripts with lines of the form :- Alter index <whatever> to cluster with maybe 80 lines in it at most is hardly a major task especially since it only needs to be setup once and perhaps have a few lines added as new tables appear. Clicking on the index name in a GUI or typing 5 words - hardly much difference! -- David Williams