Re: pctfree and pctused

Mark D. Powell wrote:-

>In theory a pctfree of 0 will work for a table where no updates or
>deletions take place and since no deletions occur the pctused setting
>will not really matter. However, I would not use a pctfree below 05
>because someday someone will add another column to the table and
>populate it or there will be a mass update to change some existing
>value to a replacement value. If you leave zero free space then this
>event will chain every row causing the update and future selects to run
>poorly

Many thanks for the information.

I had a feeling that pctused was irrelevant but was uncertain as to what to set it to.

I was inclined to set pctfree to 0 but will use your suggestion and set it to 5%

Regards

Neil Jellis Received on Wed May 03 2000 - 00:00:00 CDT