Archives of the TeradataForum

Message Posted: Tue, 05 Nov 2002 @ 17:40:19 GMT

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

I can't answer your main question, but shouldn't you have another column in this table to serve as a primary index? I don't think the varbyte column is a wise choice. Perhaps something like this:

create table filedb (
piece_num integer,
piece varbyte(64000)
)
unique primary index(piece_num);

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