Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table allocates space on empty columns?
You should read about PCTFREE instead, I presume.
Tom Pall wrote:
Be careful about columns which are empty upon insert but have dataReceived on Sat Jan 30 1999 - 21:17:26 CST
placed in them during updates. This can result in chained rows, which
degrades performance. If rows are updated so that there is not enough
room in the block to hold them, Oracle will continue a row in the next
block. If your application inserts rows with empty columns which are
later filled, read about using PCTINCREASE in the Server Concepts manual
to avoid this.