Re: pctincrease 0 or pctincrease 1 is better?

        Use multiple tablespaces each with all objects of a uniform size. For example, in the last database I set up I had separate tablespaces for tables of up to 100K, 1M, 10M, 100M, 1000M, and GL (GL contains the only table that will ever exceed 1GB).

        I also have corresponding index tablespaces

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/19/00, 10:19:20 AM, "Terry Dykstra" <dontreply tdykstra_at_cfol.ab.ca>  

wrote regarding Re: pctincrease = 0 or pctincrease = 1 is better?:

> What real life database has ever segments that you can size the same
 way?
> Tables, indexes come in every size, from very small to very big.
 Isn't this
> whole idea of identically sized segments wishful thinking?
 

> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
Received on Tue Jun 20 2000 - 00:00:00 CDT