Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> after rebuild, PK indexes are larger?

after rebuild, PK indexes are larger?

From: Rose Skubiszewski <skubiszewski_at_Encompasserve.org>
Date: Thu, 14 Mar 2002 18:02:28 +0000 (UTC)
Message-ID: <a6qojk$8th$1@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.
Received on Thu Mar 14 2002 - 12:02:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US