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 fastindexweightloss_at_skinnydata.com for
details.
- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> I'm sure it's #6 :)
>
>
> --- Jack Silvey <jack_silvey_at_yahoo.com> 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)"
> > > <MATT.ADAMS_at_APPL.GE.COM>
> > > 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 -
> > > matt.adams_at_appl.ge.com
> > > > 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: wisernet100_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: jack_silvey_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: jack_silvey_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri May 31 2002 - 13:36:59 CDT