Re: alter index

Sadagopan, Sathish wrote: > > Hi, > Is Alter index to cluster a good idea to force contiguity and free up space > than > doing a dbexport/dbimport , what are the pros and cons ? It depends on the version. Most ALTER commands now do in-place alters. So the only sure way at this stage, is ALTER FRAGMENT, even if the table is not fragmented. The dbexport/dbimport commands would defrag a whole database. You could use UNLOAD/LOAD commands in SQL for a single table. Just be careful with dbexport/dbimport, or UNLOAD/LOAD, because you could end up with exactly the same fragmented (non-contiguous extents) table, if that's the only available space in the dbspace. Unless you explicitly set the initial extent size. Even then, the extent sizes will be overridden with the actual space available, if it is less. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+