Re: after rebuild, PK indexes are larger?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 14 Mar 2002 20:53:13 -0000
Message-ID: <3c910e99$1_3@mk-nntp-1.news.uk.worldonline.com>

"Rose Skubiszewski" <skubiszewski_at_Encompasserve.org> wrote in message news:a6qojk$8th$1_at_grandcanyon.binc.net...
> I rebuilt the indexes on the hottest tables and noticed that
> the all the primary key indexes became larger but all the
> regular indexes became smaller. I expected the indexes to
> rebuild smaller, or close to the original size, not larger.
>
> Can anyone explain this behavior with rebuilding PK indexes?
> The environment is v7.3.4 on NT4. Thanks.

OLTP is probably inserting new entries in the pctfree space. Provided the index storage parameters are reasonable, I wouldn't worry about the extra space used.

HTH. Paul Received on Thu Mar 14 2002 - 14:53:13 CST