Re: Fragmenation Question

On Wed, 05 Jan 2000 05:55:00 GMT, dmausner_at_ameritech.x.net (dave mausner) wrote:

>a larger pctfree (then the default of 10) doesn't mean more fragmentation
>on the initial load; it just means that the table will initially be larger
>or have more extents or have a higher high-watermark. fragmentation is bad
>because logically adjacent rows are physically far apart. that doesn't
>occur just because pctfree > 10. rest assured the db will still be clean.
>
>if you set pctfree=50 (for example) the data will be more spread out and
>occupy more blocks. a full scan of the table visits more blocks and does
>twice the i/o, as the same data loaded with pctfree=0.

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?
(I've never touched this params when creating a table because I don't understand completely their meaning).

Thanks.

jgonzalezsNO_at_SPAMoviedo.syseca.es
(remove NO and SPAM) Received on Mon Jan 10 2000 - 02:55:52 CST