Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2015 @ 20:13:00 GMT


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


Subj:   Re: Copy N records from one table to another
 
From:   Gregg, William

Use the sample capability -- Sample 1e8 or Sample 100000000 -- to capture the data.

Top N is not a random sample, but it is slightly faster in this circumstance.

The sampling adds one step to your Explain.


Rgrds,

Bill Gregg



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