Lose 20 blocks in 10 days! Load as much as you normally do and still lose index width.
no segment size restrictions or tiring delete routines that never seem to finish. easy-to-follow substr(column,1,1) update routine that guarentees a maximum of data loss and a minimum of storage! email to [EMAIL PROTECTED] for details. --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > I'm sure it's #6 :) > > > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > Matt, > > > > 1) Storage parameter changes? Do you specify > storage > > at the index or tablespace (or top partition) > > level?pctfree go up? initrans go up? bigger > INITIAL or > > NEXT? > > > > 2) did you build it the first time using > parallelism > > and rebuild using single thread? When a PQ > processes > > is used to build an object it uses its own extent, > and > > then *deallocates the extra space* at the end. If > you > > will notice, when you build using PQ your segments > > have wacko sizes, and that is why. > > > > If you rebuilt using a single process, it could be > > that you have a full allocation of space, some > empty. > > > > 3) more data? did you "alter unusable", load, and > > rebuild? > > > > 4) have you changed the minimize_records_per_block > > parameter and the index is a bitmap? > > > > 5) has your data distribution changed? bitmap > indexes > > tend to get bigger as your data moves towards high > > cardinality. > > > > 6) has this index been eating too much sugar > again? > > sometimes, this can cause an index glucose spike > and > > tend to make it store more fat in the leaf blocks, > > especially around the middle of the index, but > > sometimes on the hips too. Perhaps you are not > doing > > DDL on the table enough, and so the index is not > > getting enough exercise. > > > > hth, > > > > jack silvey > > > > > > > --- "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). > > > > > > __________________________________________________ > > 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: Jack Silvey > > 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). > > > __________________________________________________ > 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). __________________________________________________ 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: Jack Silvey 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).
