Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 21:22:03 GMT


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


Subj:   How sample works?
 
From:   Sonje, Zdravko

Can someone explain how "sample" works?

Explain for "select * from table1 sample 100" says:

     (all_amps), which is built locally on the AMPs.  The result
     spool file will not be cached in memory.  The size of Spool 3
     is estimated with low confidence to be 11,767,538 rows.  The
     estimated time for this step is 3 hours and 58 minutes.

Table table1 has 300 m records and I need only 100 records. What is the trick?


Thanks,

Zdravko Sonje



     
  <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: 27 Dec 2016