Re: alter index

Mark D. Stock wrote: > > 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. Mark, you do not want to say that we perform an "in-place" ALTER INDEX TO CLUSTER, do you ? Bye Stefan Weideneder > 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"!|/ ////////| > +----------------------+-----------------------------------+-----------+