Archives of the TeradataForum

Message Posted: Tue, 31 May 2011 @ 20:32:44 GMT

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

Sample the table.

Consider building a table with the same DDL and insert 999 rows chose at random from the source table.

SQL is like this: Insert into small_tbl select * from big_tbl sample 999;

Sample sizes of 50 are excellent for manual inspection.

Rgrds,

Bill Gregg, Teradata DBA

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