Re: rebuild vs resize

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Tue, 3 Oct 2000 10:44:55 -0500
Message-ID: <8rcusa$put$1@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 - 10:44:55 CDT