Archives of the TeradataForum

Message Posted: Fri, 28 Apr 2006 @ 22:14:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Teradata does not get a new block and copy the data into it. It requests a space on disk which is adequate to store the new (expanded) data block, writes the updated data block to that location and then releases the old location on the disk. No mem copy involved. As noted above, this happens in any case where the block changes size or grows beyond the available space in its current location.

There is a third option. If the expanded data block exceeds the maximum block size, it is split in half and the two halves are written to disk as two new data blocks.

	<Prev	Next>		<<First	<Prev	Next>	Last>>