Extent size

Posted in 1998

Albert Wisse — Fri, 29 May 1998 11:47:50 +0200 — source: Informix-list mailing list archive (1991-1998)

-- Hello, I have a database with many tables, a few thousand tables and due the behavior of the product I can`t set the initial extent size so that the amount of extents is minimal. Why can't I do the following; "with alter index ?? to cluster" I recreate the table in the order given by the index so why not having the possibility to reset the initial extent size to ("size of the table"/n)+("initial extent size"/p) and the next extent size to ("initial extent size/p"). The n and p parameters are extra options to "alter index ?? to cluster" command. This gives my the possibility to rebuild the database in the weekend, automate it. Regards, __ _/ __ Albert Wisse \\ \\\\// / Cayenne Software Customer Services \\ \\/ / Olof Palmestraat 24 wissea@cayennesoft.nl C A \\ / E N N E 2600 GB Delft (+31) 15 21 519 10/19 / / the Netherlands (+31) 15 212 0267 (Fax) /_/ http://www.cayennesoft.com Cayenne Software is a Bachman and Cadre company