Re: Table allocates space on empty columns?

Be careful about columns which are empty upon insert but have data 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. Received on Sat Jan 30 1999 - 14:33:28 CST