Indexes - PCTFREE should be small?

From: <robertchung0909_at_my-deja.com>
Date: Fri, 15 Sep 2000 21:07:30 GMT
Message-ID: <8pu320$oag$1@nnrp1.deja.com>

This is my understanding: Indexes never shrink, but only grow ---> Having free space does not help ---> Therefore PCTFREE for indexes should be small.

I believe above is right. Having free space for *tables* do help because they do delete/update/insert data and Oracle can simply put additional data to current data block instead of chaining data to new datablock if free space is available in current block.

Assuming so, it is logical to choose small PCTFREE (even 0) for indexes. However, virtually everyone that I know assigns 10 for PCTFREE for every index. Could someone comment on this? Thank you in advance.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 15 2000 - 16:07:30 CDT