Re: number of extents question

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<x9wf9.29168$g9.83917_at_newsfeeds.bigpond.com>...
> But would I rebuild a table if it had 10 or 20 or 100 extents. No.

I agree. But I remember Jonathan Lewis seems to say if the number of extents exceeds 50 or 100, rebuilding the segment may be warranted. I don't have the book here so I may be misreading him.

By the way, I never alter table/index coalesce, and I always use compress=n in export. I'd like to hear others' opinion.

Yong Huang Received on Wed Sep 11 2002 - 16:48:35 CDT