Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Testing Large Teradata tables
From:   Gregg, William

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.


Bill Gregg, Teradata DBA

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023