Re: initial extent is LESS THAN first extent size :WHY??

jeffso@lucent.com wrote: > > So, similar question, if I have a large table over 5G, somehow, I delete some of > the records and make it about 3G. Now, if I issue an ALTER INDEX TO CLUSTER on > this table, what will happen? Will this operation be successful? Since there > is no chunk can be bigger than 2G and I am now trying to get a continuous spaces > for 3G. The ALTER INDEX TO CLUSTER option is used to cluster data rows in the same order as the index. As a SIDE EFFECT it will remove unused pages. But as Art said the other day, this effect will not occur with in place ALTER statements. Allocating extents to a table with no activity on that dbspace, will result in a single extent, or in your case two extents being allocated. However, it is quite possible to run ALTER INDEX TO CLUSTER and see no change in the number of extents allocated to the table. Extents are allocated as contiguous space. But if there is no contiguous space, the extents will be slotted in where there is space, which could be just as scattered as before. Hope that helps, -- 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"!|/ ////////| +----------------------+-----------------------------------+-----------+