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.


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: 24 Jul 2020