Re: fragmentation factor

Posted in 2005

Colin Dawson — Thu, 13 Oct 2005 14:01:02 +0000 — source: Usenet: comp.databases.informix

Neil, It was a reference to DCH's comment about correctly sizing a table and also to add that if you hit the limit you will have to fragment Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Neil Truby" <neil.truby@ardenta.com> >Reply-To: "Neil Truby" <neil.truby@ardenta.com> >To: informix-list@iiug.org >Subject: Re: fragmentation factor >Date: Wed, 12 Oct 2005 19:26:06 +0100 > >"Colin Dawson" <cjd_1955@hotmail.com> wrote in message >news:1129130055.7771deea52eeb37ea26e65f577dd240e@teranews... > > > > Unless, of course, you are running 7.31 and reach the max number of >pages > > in > > a table (16777215) :) > > >It's actually tablespace rather than table (can't remmeber if this is >relevant because I'm not sure which post you're replying to - viewing >through the newsgroup I seem to lose about half of all posts these days). > >But it still pertains in 9.40 certainly and, I believe, 10.0 sending to informix-list