pctfree parameter for PK indexes based on running sequences.

Hello Experts,

We have around 400 primary key indexes,all are based on running sequences. The DDL that creates these sequences has pctfree of 10%. I recently read that pctfree is absolutely meaningless for indexes that are based on running sequences ...because it is meant to be there to allow for new inserts/updates etc , but in the case I refer, these updates will not be in existing nodes , they will allways be in the last leaf node ..So the conclusion is that for these indexes the pctfree of 0 could have saved us lots of space.

I would be thankful if you can share your views on this.

S. Received on Sat Sep 17 2005 - 11:47:55 CDT