Re: Index rebuilds

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 08 Oct 2003 14:01:35 GMT
Message-ID: <3NUgb.141863$bo1.135382@news-server.bigpond.net.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1065621056.435683_at_yasure...
> Neil Emery wrote:
>
> >In the "olden" (or should that be golden?) days we were all recommended
to
> >regularly export and import
> >tables where a large number of inserts/deletes occurred to 'tidy' them
up.
> >Am i correct in saying that this is no longer required with oracle 7/8/9
?
> >
> >TIA
> >
> >Neil
> >
> >
> You would not be correct as you stated it.
>
> What I would say is that you should not need to do it provided you are
> using locally managed rather than
> dictionary managed tablespaces and that all hard and fast rules are
> always wrong.
>

Hi Daniel,

I would suggest that providing you've used DMTs correctly, in that you have index with correctly sized extents that don't have a massive number of extents associated with them, then the requirements for a rebuild would be just as uncommon regardless of the type of tablespace.

Considering of course that all hard and fast rules are usually wrong ;)

Cheers

Richard Received on Wed Oct 08 2003 - 09:01:35 CDT