Re: Another fillfactor question

Sujit Pal wrote: > > Hi All > > We have a program which does a month-end purge and archive process. > One = > of the things we are doing is to drop and recreate tables with the = > qualifying rows after that. Some of our indexes have fillfactors > defined = > by the DBA at the time of creation. Is there some way using the system > = > catalog where we can find the fillfactor setting for the current > index? In short, no. The fill factor is only used at creation time, so there is no need to store the value. Remember, that after creation, you will start filling nodes past the fill factor. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ 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"!|/ ////////| +----------------------+-----------------------------------+-----------+