Archives of the TeradataForum

Message Posted: Mon, 31 Jul 2006 @ 20:59:58 GMT

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

Per the "Database Design" manual:

"One LOB subtable is required for each column in a base table defined with a BLOB or CLOB data type."

"Each LOB is stored in 64 Kbyte sections in a subtable, except for the row that stores the last section. This means that for any LOB greater than 64 Kbytes, there is not a 1:1 equivalence between the number of base table rows and the number of LOB subtable rows supporting those base table rows."

jdg

www.jgraas.com

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