Re: after rebuild, PK indexes are larger?

Rose Skubiszewski wrote:
>
> 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.

pctfree is observed only when you create/rebuild an index. Thus you could easily have:

index starts at pctfree 10 (ie 90% full) regular dml had packed the blocks to 95% full rebuild forces the index back to 90% full - ie bigger

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."