Re: rebuild vs resize

From: Van Messner <vmessner_at_bestweb.net>
Date: Tue, 03 Oct 2000 22:05:31 GMT
Message-ID: <LKsC5.2649$np1.336507@newshog.newsread.com>

Oracle has changed what it says about thrown extents since version 7. They now say that, except for some unusual circumstance, 50 would not be a problem. For the rest I agree with Kevin.

Van

"Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote in message news:8rcusa$put$1_at_news.gte.com...
>
> The two "options" below are one in the same, if the "alter index rebuild"
> has proper storage options.
>
> 50 of any size extent on a single object, in my opinion, is not a problem.
> As for performance, unless you are changing PCTFREE to a smaller value
upon
> rebuild OR you have a large percentage of DEL_LF_ROWS, I wouldn't think a
> rebuild would change a thing.
>
> -Kevin
>
> "Eddie King" <eddie_king_at_email.msn.com> wrote in message
> news:OGv5KQULAHA.330_at_cpmsnbbsa09...
> > in our Oracle 7 database, I found an index that 50 extents (max ext =
99).
> > would an "alter index xxx rebuild" improve performance more than
resizing
> > the index, putting all the current extents into one contigous extent?
> >
> > thanks,
> > Eddie
> >
> >
>
>
Received on Tue Oct 03 2000 - 17:05:31 CDT