This question is in response to the paper:
"Avoiding a Database Reorganization"
by Craig A. Shallahamer.
Having a higher PCTFREE for a table will reduce the number of chained
rows during updates; however, it will increase the initial amount of
table block fragmentation. Has anyone studied the trade off between
these two types of fragmentation? Which type causes the biggest
performance issues? What types of applications would be hit hardest by
choosing to reduce one type by increasing the other. Are there other
papers about this floating around somewhere?
Received on Tue Jan 04 2000 - 16:11:45 CST
