Re: Please comments This Tablespace Setup

[Quoted] On Wed, 19 Jul 2000 18:47:27 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

<<snip>>
>
>PCTINCREASE should never be anything other than zero (fragmentation).
>MAXEXTENT of 505?? Unusual number...but regardless,

>for optimal
>performance, no segment should ever have more than half a dozen extents.

I can't let that one slip by I'm afraid ! The number of segments makes no differance to performance apart from

1. the time it takes to drop the object
2. parallel operations on very busy tables

unless you're in the thousands range

Regards

Alex

<<snip>> Received on Thu Jul 20 2000 - 00:00:00 CEST