RE: rebuilding indexes

[Jeffrey Beckstrom]

But when you rebuild, it will reestablish the pctfree in all of the index blocks.  If you had a lot of activity this free space would have been used in the original index and is now reclaimed.   Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> [EMAIL PROTECTED] 5/31/02 1:11:54 PM >>> storage parameter difference?  None  are you moving from one tablespace to another without specifying parameters?  No pctfree/pctused influence?  none I should have put this in the original message. Indexes stayed in original tablespace with identical storage parameters, but number of extents went from 20 to 25 (each extents is 65 8-K blocks) ---- Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user friendly.  It's just particular about who it makes friends with. -----Original Message----- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: rebuilding indexes storage parameter difference?  are you moving from one tablespace to another without specifying parameters? pctfree/pctused influence? --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> wrote: > Under what conditions would an 'alter index .. rebuild' > actually case the size of the index to increase > by about 12 percent? > > > > ---- > Matt Adams - GE Appliances - [EMAIL PROTECTED] > Contrary to popular opinion, Unix is user friendly.  > It's just particular about who it makes friends with. > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).