Re: Fragmenation Question

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 05:57:08 GMT
Message-ID: <8EB7F3351dlm@206.141.192.241>

markp7832_at_my-deja.com wrote in <85d5li$ecc$1_at_nnrp1.deja.com>:

>In article <bJ55OI0HN0bPafA00Tnicb3zPj5W_at_4ax.com>,
> jgonzalezsNO_at_SPAMoviedo.syseca.es wrote:
>> On Wed, 05 Jan 2000 05:55:00 GMT, dmausner_at_ameritech.x.net (dave
>> mausner) wrote:
>> So, What's the *best* settings for pctfree and pctused params for a
>> table of historical data, which you insert data along time but never
>> update or delete?

the correct answer is pctfree=0 (pctused doesn't matter) for a table of historial data which never changes. this means you do not intend to add columns, either.
--
dave mausner Received on Mon Jan 10 2000 - 23:57:08 CST